parameterHolder:
  action: details
  isBlindProject: false
  module: contests
  page: '2'
  sf_culture: en_US
  slug: referral-program
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: {  }
  imgpreview: {  }
  jquery.bettertip.pack.js: {  }
stylesheets:
  layout.css?v=1.41: {  }
  thickbox: {  }
  draft_listing?v=1.29: {  }
  jquery.bettertip.css: {  }
metas:
  title: 'Referral Program - Other Project for a Alhambra based company by MycroBurst.com'
  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
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: 01r5npq4o06rhipub4rr8u3dt6
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: '2'
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=01r5npq4o06rhipub4rr8u3dt6
  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: /contests/referral-program
  PATH_TRANSLATED: 'redirect:/index.php/referral-program'
  PHP_SELF: /mbdev_.php/contests/referral-program
  QUERY_STRING: page=2
  REMOTE_ADDR: 216.73.216.139
  REMOTE_PORT: '50974'
  REQUEST_METHOD: GET
  REQUEST_TIME: 1751965955
  REQUEST_URI: /mbdev_.php/contests/referral-program?page=2
  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/authenticated: false
  symfony/user/sfUser/credentials: {  }
  symfony/user/sfUser/culture: fr
  symfony/user/sfUser/lastRequest: 1751965955

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 c.id AS c__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.wl_id AS c__wl_id, c.status AS c__status, c.launch_date AS c__launch_date, c.end_date AS c__end_date, c.total_drafts AS c__total_drafts, c.is_featured AS c__is_featured, c.slug AS c__slug, c.user_id AS c__user_id, c.show_thumbs AS c__show_thumbs, c.site_id AS c__site_id, s.id AS s__id, s.username AS s__username, s.city AS s__city, c2.id AS c2__id, c2.additional_option_id AS c2__additional_option_id, s2.id AS s2__id, s2.name AS s2__name, s2.slug AS s2__slug 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 LEFT JOIN services s2 ON c.service_id = s2.id WHERE c.slug = ? AND c.status NOT IN (?, ?) - (referral-program, pending, new )
2. SELECT COUNT(*) AS num_results FROM contest_options c WHERE c.additional_option_id = ? AND c.contest_id = ? - (3, 99443 )
3. SELECT COUNT(*) AS num_results FROM (SELECT d.id FROM drafts d LEFT JOIN sf_guard_user s ON d.user_id = s.id WHERE d.status != ? AND d.contest_id = ? GROUP BY d.id) dctrn_count_query - (delete, 99443 )
4. SELECT COUNT(*) AS num_results FROM (SELECT c.id FROM comments c LEFT JOIN sf_guard_user s ON c.user_id = s.id WHERE c.is_active = ? AND c.designer_id is null AND c.contest_id = ? GROUP BY c.id) dctrn_count_query - (1, 99443 )
5. SELECT w.id AS w__id, w.user_id AS w__user_id, w.contest_id AS w__contest_id, w.draft_id AS w__draft_id, w.amount AS w__amount, w.approved AS w__approved, w.prize_type AS w__prize_type, w.winner_type AS w__winner_type, w.payment_type AS w__payment_type, w.payment_status AS w__payment_status, w.mb_fee AS w__mb_fee, w.prize_money AS w__prize_money, w.addition AS w__addition, w.deduction AS w__deduction, w.amount_comment AS w__amount_comment, w.file_received_date AS w__file_received_date, w.file_sent_date AS w__file_sent_date, w.file_comment AS w__file_comment, w.paypal_email AS w__paypal_email, w.transaction_id AS w__transaction_id, w.payment_comment AS w__payment_comment, w.draft_keywords AS w__draft_keywords, w.created_at AS w__created_at, w.updated_at AS w__updated_at, 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, d.id AS d__id, d.user_id AS d__user_id, d.contest_id AS d__contest_id, d.draft_number AS d__draft_number, d.file_name AS d__file_name, d.status AS d__status, d.rating AS d__rating, d.thumb_up AS d__thumb_up, d.thumb_down AS d__thumb_down, d.is_shared AS d__is_shared, d.add_to_portfolio AS d__add_to_portfolio, d.ip AS d__ip, d.created_at AS d__created_at, d.updated_at AS d__updated_at FROM winners w LEFT JOIN contests c ON w.contest_id = c.id LEFT JOIN drafts d ON w.draft_id = d.id WHERE w.contest_id = ? ORDER BY w.id ASC - (99443 )
6. SELECT COUNT(*) AS num_results FROM contest_options c WHERE c.additional_option_id = ? AND c.contest_id = ? - (3, 99443 )
7. SELECT d.id AS d__id, d.draft_number AS d__draft_number, d.file_name AS d__file_name, d.rating AS d__rating, d.user_id AS d__user_id, d.status AS d__status, d.add_to_portfolio AS d__add_to_portfolio, 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 FROM drafts d LEFT JOIN sf_guard_user s ON d.user_id = s.id WHERE d.status != ? AND d.contest_id = ? ORDER BY d.status='active' DESC, d.rating DESC, d.draft_number DESC LIMIT 40 OFFSET 40 - (delete, 99443 )
8. SELECT c.id AS c__id, c.comment AS c__comment, c.created_at AS c__created_at, c.user_id AS c__user_id, 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 FROM comments c LEFT JOIN sf_guard_user s ON c.user_id = s.id WHERE c.is_active = ? AND c.designer_id is null AND c.contest_id = ? ORDER BY c.created_at DESC LIMIT 25 - (1, 99443 )