parameterHolder:
  action: index
  module: contests
  page: '402'
  sf_culture: en_US
attributeHolder:
  sf_route: 'sfRoute Object()'

options:
  http_protocol: HTTP/1.0
  logging: '1'
  charset: utf-8
  send_http_headers: true
  content_type: 'text/html; charset=utf-8'
cookies: {  }
httpHeaders:
  Content-Type: 'text/html; charset=utf-8'
javascripts:
  jquery/js/jquery-1.5.1.min.js: {  }
  thickbox: {  }
stylesheets:
  layout.css?v=1.41: {  }
  thickbox: {  }
metas:
  title: 'Browse Design Projects >> MycroBurst'
  description: 'Get 50 to 150+ quality designs, by thousands of designers in just a few days. Get custom logo design, web design, brochure design and graphic design. Only pay for your favorite design, and see your designs in hours not weeks!'
  keywords: 'crowdsource, logo design, web design, graphic design, spec work'
  language: en
  robots: 'index, follow'
httpMetas:
  Content-Type: 'text/html; charset=utf-8'

options:
  auto_shutdown: false
  culture: en_US
  default_culture: en_US
  use_flash: true
  logging: '1'
  timeout: 3600
attributeHolder:
  symfony/user/sfUser/attributes: { referer: '' }
culture: en_US

app_affiliates_bucket: dev.affiliate.logos
app_affiliates_logo_url: 'http://s3.amazonaws.com/dev.affiliate.logos'
app_affiliates_url: mycreativesamples.com
app_avatar_bucket: dev.user.avatars
app_avatar_url: 'http://s3.amazonaws.com/dev.user.avatars'
app_comments_display_per_page: 25
app_contestEUR_EUR: '€'
app_contestEUR_EUR_JS: \u20AC
app_contestEUR_banneradssize_large: 15
app_contestEUR_banneradssize_small: 12
app_contestEUR_default_service: 1
app_contestEUR_display_per_page: 30
app_contestEUR_donationAmount1: 20
app_contestEUR_donationAmount2: 40
app_contestEUR_donationAmount3: 77
app_contestEUR_extend_expedite_fee: 22
app_contestEUR_extend_fee: 22
app_contestEUR_listing_fee: 0
app_contestEUR_min_mulwinner_prize: 40
app_contestEUR_prize_handling_fee: 20
app_contestGBP_GBP: '£'
app_contestGBP_GBP_JS: \u00A3
app_contestGBP_default_service: 1
app_contestGBP_display_per_page: 30
app_contestGBP_donationAmount1: 20
app_contestGBP_donationAmount2: 35
app_contestGBP_donationAmount3: 70
app_contestGBP_extend_expedite_fee: 20
app_contestGBP_extend_fee: 20
app_contestGBP_listing_fee: 0
app_contestGBP_min_mulwinner_prize: 35
app_contestGBP_prize_handling_fee: 20
app_contestUSD_USD: $
app_contestUSD_USD_JS: $
app_contestUSD_default_service: 1
app_contestUSD_display_per_page: 30
app_contestUSD_donationAmount1: 25
app_contestUSD_donationAmount2: 50
app_contestUSD_donationAmount3: 100
app_contestUSD_extend_expedite_fee: 29
app_contestUSD_extend_fee: 29
app_contestUSD_listing_fee: 0
app_contestUSD_min_mulwinner_prize: 50
app_contestUSD_prize_handling_fee: 20
app_contest_1to1_fee: 20
app_contest_1to1_service_id: 10
app_contest_default_service: 1
app_contest_display_per_page: 30
app_contest_extend_expedite_fee: 29
app_contest_extend_fee: 29
app_contest_listing_fee: 0
app_contest_min_mulwinner_prize: 50
app_contest_prize_handling_fee: 20
app_designers_display_per_page: 20
app_drafts_bucket: devmb
app_drafts_display_per_page: 40
app_drafts_large_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/large
app_drafts_medium_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/medium
app_drafts_original_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/original
app_drafts_small_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/small
app_drafts_tiny_dir: /vol/vhosts/www.mycroburst.com/httpdocs/drafts/tiny
app_drafts_url: 'http://d1t9cmz3kkfuyi.cloudfront.net'
app_email_bcc: info@mycroburst.com
app_email_comments: comments@mycroburst.com
app_email_finalization: finalization@mycroburst.com
app_email_from: info@mycroburst.com
app_email_new_projects: newprojects@mycroburst.com
app_email_partnerorder: partner.orders@mycroburst.com
app_email_private_message: pm@mycroburst.com
app_email_report_abuse: report@mycroburst.com
app_email_support: support@mycroburst.com
app_email_transactions: transactions@mycroburst.com
app_email_webpartner: webpartner@mycroburst.com
app_files_bucket: dev.contest.files
app_files_dir: /vol/vhosts/www.mycroburst.com/httpdocs/files
app_files_url: 'http://s3.amazonaws.com/dev.contest.files'
app_payflow_partner: PayPal
app_payflow_password: kamlesh123
app_payflow_url: 'https://pilot-payflowpro.paypal.com'
app_payflow_user: kamlesh
app_payflow_vendor: kamlesh
app_paymentpro_password: P4V9TPQ4V74Q8U86
app_paymentpro_signature: AOdinqNqM4HJ3tKB5t7C87IdnrExALWTTdrZojxpm5.006HBae.A6QeE
app_paymentpro_url: 'https://api-3t.sandbox.paypal.com/nvp'
app_paymentpro_user: prismaticdesire_api1.yahoo.com
app_paypal_email: kkumar@verticity.com
app_paypal_url: 'https://www.sandbox.paypal.com/cgi-bin/webscr'
app_s3_access_key: AKIAJDPTXCEOIQQ3Q4PQ
app_s3_secret_key: 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
app_sf_guard_plugin_masterpassword: JGH!84jh@L
app_sf_guard_plugin_remember_cookie_name: mycroburstRemember
app_sf_guard_plugin_remember_key_expiration_age: 7776000
app_sf_guard_plugin_routes_register: false
app_site_currency_fr: '€'
app_site_currencycode_fr: EUR
app_site_id: 1
app_site_id_fr: 6
app_site_name: MycroBurst.com
app_site_smtp_mailserver: 192.99.195.132
app_site_smtp_password: test321321
app_site_smtp_username: test@mycreativesamples.com
app_site_wlaffiliate_id_fr: 6
app_sitesdevurl_1: 'http://dev.mycroburst.com/mbdev_.php'
app_sitesdevurl_2: 'http://dev.logoguru.co.uk/gurudev_.php'
app_sitesdevurl_3: 'http://dev.orders.logodesignguru.com/ldgdev_.php'
app_sitesdevurl_4: 'http://devdesign.logosnap.com/frontend_dev.php'
app_sitesdevurl_5: 'http://dev.mycroburst.com/mbdev_.php'
app_sitesdevurl_6: 'http://dev.mycroburst.com/mbdev_.php/fr'
app_sitesdevurl_7: 'http://dev.mycroburst.com/ar/mbdev_.php'
app_sitesdevurl_8: 'http://dev.zilliondesigns.com/frontend_dev.php'
app_sitesliveurl_1: 'http://www.mycroburst.com'
app_sitesliveurl_2: 'http://www.logoguru.co.uk'
app_sitesliveurl_3: 'http://orders.logodesignguru.com'
app_sitesliveurl_4: 'http://design.logosnap.com'
app_sitesliveurl_5: 'http://www.mycroburst.com'
app_sitesliveurl_6: 'http://www.mycroburst.com/fr'
app_sitesliveurl_7: 'http://www.mycroburst.com/ar'
app_sitesliveurl_8: 'http://www.zilliondesigns.com'
app_sourcefiles_bucket: dev.contest.sourcefiles
app_sourcefiles_url: 'http://s3.amazonaws.com/dev.contest.sourcefiles'
app_tipalti_base_url: 'http://int.payrad.com/Payees/PayeeDashboard.aspx?'
app_tipalti_payer_name: Logodesignguru
app_tipalti_payment_list: 'http://int.payrad.com/Payees/PaymentList.aspx?'
app_tipalti_secret_key: LogodesignguruDemoKey
mod_contests_enabled: true
mod_contests_is_internal: false
mod_contests_view_class: sfPHP
mod_services_enabled: true
mod_services_is_internal: false
mod_services_view_class: sfPHP
sf_admin_module_web_dir: /sfDoctrinePlugin
sf_admin_web_dir: /sf/sf_admin
sf_app: frontend
sf_app_base_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend
sf_app_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev
sf_app_config_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/config
sf_app_dir: /vol/vhosts/www.mycroburst.com/apps/frontend
sf_app_i18n_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/i18n
sf_app_lib_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/lib
sf_app_module_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/modules
sf_app_template_dir: /vol/vhosts/www.mycroburst.com/apps/frontend/templates
sf_apps_dir: /vol/vhosts/www.mycroburst.com/apps
sf_cache: true
sf_cache_dir: /vol/vhosts/www.mycroburst.com/cache
sf_calendar_web_dir: /sf/calendar
sf_charset: utf-8
sf_check_lock: false
sf_check_symfony_version: false
sf_compressed: false
sf_config_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/config
sf_config_dir: /vol/vhosts/www.mycroburst.com/config
sf_csrf_secret: UniqueSecret
sf_data_dir: /vol/vhosts/www.mycroburst.com/data
sf_debug: true
sf_default_culture: en_US
sf_doc_dir: /vol/vhosts/www.mycroburst.com/doc
sf_enabled_modules:
  - default
  - sfGuardAuth
sf_environment: dev
sf_error_404_action: error404
sf_error_404_module: default
sf_error_reporting: 8191
sf_escaping_method: ESC_SPECIALCHARS
sf_escaping_strategy: true
sf_etag: false
sf_i18n: true
sf_i18n_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/i18n
sf_jquery_autocomplete: jquery.autocomplete-1.0.2.min.js
sf_jquery_core: jquery-1.5.1.min.js
sf_jquery_sortable: jquery-ui-sortable-1.6rc2.min.js
sf_jquery_web_dir: jquery
sf_lazy_cache_key: true
sf_lib_dir: /vol/vhosts/www.mycroburst.com/lib
sf_log_dir: /vol/vhosts/www.mycroburst.com/log
sf_logging_enabled: true
sf_login_action: signin
sf_login_module: sfGuardAuth
sf_max_forwards: 5
sf_module_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/modules
sf_module_disabled_action: disabled
sf_module_disabled_module: default
sf_no_script_name: false
sf_orm: doctrine
sf_plugins_dir: /vol/vhosts/www.mycroburst.com/plugins
sf_prototype_web_dir: /sfProtoculousPlugin
sf_rich_text_js_dir: js/tiny_mce
sf_root_dir: /vol/vhosts/www.mycroburst.com
sf_secure_action: secure
sf_secure_module: sfGuardAuth
sf_standard_helpers:
  - Partial
  - Cache
  - Form
  - Javascript
  - jQuery
  - Date
sf_strip_comments: true
sf_symfony_lib_dir: /usr/share/pear/symfony
sf_template_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/template
sf_test_cache_dir: /vol/vhosts/www.mycroburst.com/cache/frontend/dev/test
sf_test_dir: /vol/vhosts/www.mycroburst.com/test
sf_unavailable_action: unavailable
sf_unavailable_module: default
sf_upload_dir: /vol/vhosts/www.mycroburst.com/httpdocs/uploads
sf_use_database: true
sf_validation_error_class: form_error
sf_validation_error_id_prefix: error_for_
sf_validation_error_prefix: ' ↓ '
sf_validation_error_suffix: '  ↓'
sf_web_debug: true
sf_web_debug_web_dir: /sf/sf_web_debug
sf_web_dir: /vol/vhosts/www.mycroburst.com/httpdocs
symfony.asset.javascripts_included: false
symfony.asset.stylesheets_included: false

cookie:
  mycroburst: 404p7juik2fdjilg9cfumu0bb3
env:
  BASH_FUNC_module(): "() {  eval `/usr/bin/modulecmd bash $*`\n}"
  CVS_RSH: ssh
  G_BROKEN_FILENAMES: '1'
  HISTCONTROL: ignoredups
  HISTSIZE: '1000'
  HOME: /root
  HOSTNAME: ip-172-30-0-167
  LANG: C
  LESSOPEN: '||/usr/bin/lesspipe.sh %s'
  LOADEDMODULES: ''
  LOGNAME: root
  LS_COLORS: 'rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:mi=01;05;37;41:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.tbz=01;31:*.tbz2=01;31:*.bz=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=01;36:*.au=01;36:*.flac=01;36:*.mid=01;36:*.midi=01;36:*.mka=01;36:*.mp3=01;36:*.mpc=01;36:*.ogg=01;36:*.ra=01;36:*.wav=01;36:*.axa=01;36:*.oga=01;36:*.spx=01;36:*.xspf=01;36:'
  MAIL: /var/spool/mail/root
  MANPATH: '/root/.nvm/versions/node/v5.4.1/share/man:/usr/local/share/man:/usr/share/man/en:/usr/share/man:/usr/local/php-5.2.17/man'
  MODULEPATH: '/usr/share/Modules/modulefiles:/etc/modulefiles'
  MODULESHOME: /usr/share/Modules
  NVM_BIN: /root/.nvm/versions/node/v5.4.1/bin
  NVM_DIR: /root/.nvm
  NVM_IOJS_ORG_MIRROR: 'https://iojs.org/dist'
  NVM_IOJS_ORG_VERSION_LISTING: 'https://iojs.org/dist/index.tab'
  NVM_NODEJS_ORG_MIRROR: 'https://nodejs.org/dist'
  NVM_PATH: /root/.nvm/versions/node/v5.4.1/lib/node
  PATH: '/sbin:/usr/sbin:/bin:/usr/bin'
  PWD: /root
  SHELL: /bin/bash
  SHLVL: '3'
  SSH_CLIENT: '173.249.56.42 52304 22'
  SSH_CONNECTION: '173.249.56.42 52304 172.30.0.167 22'
  SSH_TTY: /dev/pts/1
  TERM: xterm
  USER: root
  _: /usr/sbin/httpd
files: {  }
get:
  page: '402'
post: {  }
server:
  DOCUMENT_ROOT: /var/www/html/vhosts/www.mycroburst.com/httpdocs
  GATEWAY_INTERFACE: CGI/1.1
  HTTP_ACCEPT: '*/*'
  HTTP_ACCEPT_ENCODING: 'gzip, br, zstd, deflate'
  HTTP_CACHE_CONTROL: max-age=0
  HTTP_CONNECTION: close
  HTTP_COOKIE: mycroburst=404p7juik2fdjilg9cfumu0bb3
  HTTP_HOST: www.mycroburst.com
  HTTP_USER_AGENT: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
  HTTP_VIA: '1.1 squid-proxy-5b5d847c96-cv9vg (squid/6.10)'
  HTTP_X_FORWARDED_FOR: '10.2.9.144, 216.73.216.28'
  HTTP_X_REAL_IP: 216.73.216.28
  PATH: '/sbin:/usr/sbin:/bin:/usr/bin'
  PATH_INFO: /contests
  PATH_TRANSLATED: 'redirect:/index.php'
  PHP_SELF: /mbdev_.php/contests
  QUERY_STRING: page=402
  REMOTE_ADDR: 216.73.216.28
  REMOTE_PORT: '53672'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1755853454
  REQUEST_URI: /mbdev_.php/contests?page=402
  SCRIPT_FILENAME: /var/www/html/vhosts/www.mycroburst.com/httpdocs/mbdev_.php
  SCRIPT_NAME: /mbdev_.php
  SERVER_ADDR: 127.0.0.1
  SERVER_ADMIN: support@mycroburst.com
  SERVER_NAME: www.mycroburst.com
  SERVER_PORT: '80'
  SERVER_PROTOCOL: HTTP/1.0
  SERVER_SIGNATURE: ''
  SERVER_SOFTWARE: Apache
session:
  symfony/user/sfUser/attributes: { symfony/user/sfUser/attributes: { referer: '' } }
  symfony/user/sfUser/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: en_US
  symfony/user/sfUser/lastRequest: 1755853455

php: 5.2.17
os: 'Linux ip-172-30-0-167 2.6.32-696.6.3.el6.x86_64 #1 SMP Wed Jul 12 14:17:22 UTC 2017 x86_64'
extensions:
  - 'date (5.2.17)'
  - libxml
  - openssl
  - pcre
  - 'zlib (1.1)'
  - bcmath
  - bz2
  - calendar
  - ctype
  - curl
  - 'dom (20031129)'
  - 'hash (1.0)'
  - 'filter (0.11.0)'
  - ftp
  - gd
  - gettext
  - gmp
  - session
  - iconv
  - 'standard (5.2.17)'
  - 'json (1.2.1)'
  - ldap
  - mbstring
  - mcrypt
  - 'mysql (1.0)'
  - 'SimpleXML (0.1)'
  - 'odbc (1.0)'
  - 'SPL (0.2)'
  - 'PDO (1.0.4dev)'
  - 'pdo_mysql (1.0.2)'
  - 'pdo_pgsql (1.0.2)'
  - posix
  - pspell
  - 'Reflection (0.1)'
  - imap
  - shmop
  - 'mysqli (0.1)'
  - snmp
  - soap
  - sockets
  - 'SQLite (2.0-dev)'
  - 'exif (1.4 $Id: exif.c 293036 2010-01-03 09:23:27Z sebastian $)'
  - sysvmsg
  - sysvsem
  - sysvshm
  - 'tokenizer (0.1)'
  - wddx
  - xml
  - 'xmlreader (0.1)'
  - 'xmlrpc (0.51)'
  - 'xmlwriter (0.1)'
  - 'xsl (0.1)'
  - apache2handler
  - 'apc (3.1.9)'

version: 1.2.12
path: /usr/share/pear/symfony

1. SELECT COUNT(*) AS num_results FROM (SELECT c.id FROM contests c LEFT JOIN contest_options c2 ON c.id = c2.contest_id WHERE c.status = ? AND c.service_id != 10 GROUP BY c.id) dctrn_count_query - (close )
2. SELECT DISTINCT c3.id FROM contests c3 LEFT JOIN contest_options c4 ON c3.id = c4.contest_id WHERE c3.status = ? AND c3.service_id != 10 ORDER BY c3.close_date DESC LIMIT 30 OFFSET 12030 - (close )
3. SELECT c.id AS c__id, c.title AS c__title, c.prize_money AS c__prize_money, c.currency AS c__currency, c.sub_title AS c__sub_title, c.status AS c__status, c.slug AS c__slug, c.total_drafts AS c__total_drafts, c.launch_date AS c__launch_date, c.end_date AS c__end_date, c.is_featured AS c__is_featured, c.close_date AS c__close_date, c.site_id AS c__site_id, c2.id AS c2__id, c2.additional_option_id AS c2__additional_option_id FROM contests c LEFT JOIN contest_options c2 ON c.id = c2.contest_id WHERE c.id IN ('44', '57', '54', '51', '45', '43', '33', '39', '29', '37', '32', '35', '22', '31', '30', '24', '26', '28', '19', '14', '11', '2', '1', '7', '5', '152086', '152454', '152439', '152787', '152817') AND c.status = ? AND c.service_id != 10 ORDER BY c.close_date DESC - (close )
4. SELECT c.id AS c__id, c.service_id AS c__service_id, c.user_id AS c__user_id, c.package_id AS c__package_id, c.industry_id AS c__industry_id, c.title AS c__title, c.sub_title AS c__sub_title, c.creative_brief AS c__creative_brief, c.prize_money AS c__prize_money, c.currency AS c__currency, c.listing_fee AS c__listing_fee, c.prize_handling_fee AS c__prize_handling_fee, c.additional_amount AS c__additional_amount, c.discount AS c__discount, c.active_days AS c__active_days, c.status AS c__status, c.show_thumbs AS c__show_thumbs, c.ip AS c__ip, c.launch_date AS c__launch_date, c.end_date AS c__end_date, c.close_date AS c__close_date, c.total_drafts AS c__total_drafts, c.is_featured AS c__is_featured, c.site_id AS c__site_id, c.wl_id AS c__wl_id, c.coupon_id AS c__coupon_id, c.slug AS c__slug, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM contests c WHERE c.id = ? LIMIT 1 - (152787 )
5. SELECT c.id AS c__id, c.service_id AS c__service_id, c.user_id AS c__user_id, c.package_id AS c__package_id, c.industry_id AS c__industry_id, c.title AS c__title, c.sub_title AS c__sub_title, c.creative_brief AS c__creative_brief, c.prize_money AS c__prize_money, c.currency AS c__currency, c.listing_fee AS c__listing_fee, c.prize_handling_fee AS c__prize_handling_fee, c.additional_amount AS c__additional_amount, c.discount AS c__discount, c.active_days AS c__active_days, c.status AS c__status, c.show_thumbs AS c__show_thumbs, c.ip AS c__ip, c.launch_date AS c__launch_date, c.end_date AS c__end_date, c.close_date AS c__close_date, c.total_drafts AS c__total_drafts, c.is_featured AS c__is_featured, c.site_id AS c__site_id, c.wl_id AS c__wl_id, c.coupon_id AS c__coupon_id, c.slug AS c__slug, c.created_at AS c__created_at, c.updated_at AS c__updated_at FROM contests c WHERE c.id = ? LIMIT 1 - (152817 )
6. SELECT s.id AS s__id, s.name AS s__name, s.slug AS s__slug, COUNT(IF((c.status='open' or c.status='close' or c.status='lock'), c.id, NULL)) AS c__0 FROM services s LEFT JOIN contests c ON s.id = c.service_id WHERE s.is_active = 1 GROUP BY s.id ORDER BY s.sort_order
7. SELECT COUNT(*) AS num_results FROM contests c WHERE c.service_id != 10 AND c.status IN('open','close','lock')
8. SELECT i.id AS i__id, i.name AS i__name FROM industries i WHERE i.is_active = ? ORDER BY i.name ASC - (1 )