parameterHolder:
  action: index
  module: services
  page: '1'
  sf_culture: en_US
  slug: label-design
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: 'Label Design'
  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: qlcs5217fe3gdsff4bhtu2ft27
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: '1'
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=qlcs5217fe3gdsff4bhtu2ft27
  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-fpkzw (squid/6.10)'
  HTTP_X_FORWARDED_FOR: '10.3.27.2, 216.73.216.139'
  HTTP_X_REAL_IP: 216.73.216.139
  PATH: '/sbin:/usr/sbin:/bin:/usr/bin'
  PATH_INFO: /services/label-design
  PATH_TRANSLATED: 'redirect:/index.php/label-design'
  PHP_SELF: /mbdev_.php/services/label-design
  QUERY_STRING: page=1
  REMOTE_ADDR: 216.73.216.139
  REMOTE_PORT: '34078'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1751914272
  REQUEST_URI: /mbdev_.php/services/label-design?page=1
  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: fr
  symfony/user/sfUser/lastRequest: 1751914272

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 = ? - (label-design )
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 = ? - (label-design )
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 - (51, 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 - (51, 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 ('176978') AND c.service_id = ? AND c.status IN (?) ORDER BY c.close_date DESC - (51, 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 )