parameterHolder:
  action: index
  module: services
  page: '107'
  sf_culture: en_US
  slug: a-logo
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: 'Logo Design By MycroBurst.com – See 50+ Logos in a Few Days By Top Designers.'
  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: {  }
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: {  }
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: '107'
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_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-fj6q8 (squid/6.10)'
  HTTP_X_FORWARDED_FOR: '10.1.205.74, 216.73.216.44'
  HTTP_X_REAL_IP: 216.73.216.44
  PATH: '/sbin:/usr/sbin:/bin:/usr/bin'
  PATH_INFO: /services/a-logo
  PATH_TRANSLATED: 'redirect:/index.php/a-logo'
  PHP_SELF: /mbdev_.php/services/a-logo
  QUERY_STRING: page=107
  REMOTE_ADDR: 216.73.216.44
  REMOTE_PORT: '44742'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1753255097
  REQUEST_URI: /mbdev_.php/services/a-logo?page=107
  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: {  }

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 s.id AS s__id, s.name AS s__name, s.description AS s__description, s.page_title AS s__page_title, s.page_content AS s__page_content, s.category_id AS s__category_id, s.sort_order AS s__sort_order, s.is_active AS s__is_active, s.slug AS s__slug FROM services s WHERE s.slug = ? - (a-logo )
2. SELECT s.id AS s__id, s.name AS s__name, s.description AS s__description, s.page_title AS s__page_title, s.page_content AS s__page_content, s.category_id AS s__category_id, s.sort_order AS s__sort_order, s.is_active AS s__is_active, s.slug AS s__slug FROM services s WHERE s.slug = ? - (a-logo )
3. SELECT COUNT(*) AS num_results FROM (SELECT c.id FROM contests c LEFT JOIN sf_guard_user s ON c.user_id = s.id LEFT JOIN contest_options c2 ON c.id = c2.contest_id WHERE c.service_id = ? AND c.status IN (?) GROUP BY c.id) dctrn_count_query - (1, close )
4. SELECT DISTINCT c3.id FROM contests c3 LEFT JOIN sf_guard_user s2 ON c3.user_id = s2.id LEFT JOIN contest_options c4 ON c3.id = c4.contest_id WHERE c3.service_id = ? AND c3.status IN (?) ORDER BY c3.close_date DESC LIMIT 30 OFFSET 3180 - (1, close )
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, s.id AS s__id, s.username AS s__username, s.algorithm AS s__algorithm, s.salt AS s__salt, s.password AS s__password, s.email AS s__email, s.firstname AS s__firstname, s.lastname AS s__lastname, s.phone AS s__phone, s.address1 AS s__address1, s.address2 AS s__address2, s.city AS s__city, s.state AS s__state, s.zip AS s__zip, s.country AS s__country, s.avatar AS s__avatar, s.dob AS s__dob, s.gender AS s__gender, s.url AS s__url, s.paypal_email AS s__paypal_email, s.biography AS s__biography, s.display_country AS s__display_country, s.ip AS s__ip, s.type AS s__type, s.languages AS s__languages, s.hear_about_us AS s__hear_about_us, s.site_id AS s__site_id, s.wl_id AS s__wl_id, s.is_active AS s__is_active, s.is_featured AS s__is_featured, s.is_super_admin AS s__is_super_admin, s.last_login AS s__last_login, s.source AS s__source, s.created_at AS s__created_at, s.updated_at AS s__updated_at, c2.id AS c2__id, c2.contest_id AS c2__contest_id, c2.additional_option_id AS c2__additional_option_id, c2.price AS c2__price FROM contests c LEFT JOIN sf_guard_user s ON c.user_id = s.id LEFT JOIN contest_options c2 ON c.id = c2.contest_id WHERE c.id IN ('111617', '111628', '111614', '110241', '111608', '111590', '111600', '111456', '111469', '111459', '111414', '111417', '108931', '111376', '111343', '111209', '111308', '107696', '110298', '106221', '111263', '111270', '111265', '111212', '111202', '111123', '111122', '111145', '109980', '109219') AND c.service_id = ? AND c.status IN (?) ORDER BY c.close_date DESC - (1, close )
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 )