Искусственные елки 180 см

SELECT *
FROM store
WHERE REPLACE(`url`, 'www.', '') = 'http://novelki.ru/'

SELECT *
FROM setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC

SELECT *
FROM language
WHERE status = '1'

SELECT *
FROM currency

SELECT *
FROM weight_class wc

SELECT *
FROM length_class mc

SELECT *
FROM url_alias
WHERE keyword IN ('iskusstvennye-elki-180sm')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM category c
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c2s.store_id = '0' AND c.status = '1'
ORDER BY c.parent_id, c.sort_order, c.name

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT COUNT(DISTINCT p.product_id) AS total
FROM product p
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE p.status = '1' AND p.date_available <= NOW() AND p2s.status = '1' AND p2s.store_id = '0' AND p2c.store_id = '0' AND p2c.category_id = '924'

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT DISTINCT p2c.category_id, c.name as name, c.image as image, c.parent_id, c1.name as name_parent
FROM product_to_category p2c
LEFT JOIN category c ON (p2c.category_id = c.category_id)
LEFT JOIN category c1 ON (c.parent_id = c1.category_id)
WHERE p2c.product_id IN ('2019','22074','72329','72332','72336','72596','72599','72602','72666','72670','405755','405765','405768','405774','405780','405792','405796','405798','405805','411105','414657','414667','414704','414705','414714','414719','414864','414875','414878','414883','414887','414892','414896','414903','414907','414911','414919','414925','414929','414934','414937','414948','414962','414964','414967','414976','414986','415047') AND p2c.main_category='1' AND p2c.store_id = '0' GROUP BY p2c.category_id
ORDER BY c.sort_order, c1.sort_order

SELECT *
FROM product_image
WHERE product_id = '411105'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '411105'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=411105')

SELECT *
FROM product_image
WHERE product_id = '414948'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414948'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414948')

SELECT *
FROM product_image
WHERE product_id = '414657'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414657'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414657')

SELECT *
FROM product_image
WHERE product_id = '414962'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414962'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414962')

SELECT *
FROM product_image
WHERE product_id = '414667'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414667'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414667')

SELECT *
FROM product_image
WHERE product_id = '414964'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414964'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414964')

SELECT *
FROM product_image
WHERE product_id = '414704'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414704'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414704')

SELECT *
FROM product_image
WHERE product_id = '414967'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414967'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414967')

SELECT *
FROM product_image
WHERE product_id = '414705'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414705'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414705')

SELECT *
FROM product_image
WHERE product_id = '414976'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414976'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414976')

SELECT *
FROM product_image
WHERE product_id = '414714'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414714'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414714')

SELECT *
FROM product_image
WHERE product_id = '414986'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414986'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414986')

SELECT *
FROM product_image
WHERE product_id = '414719'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414719'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414719')

SELECT *
FROM product_image
WHERE product_id = '415047'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '415047'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=415047')

SELECT *
FROM product_image
WHERE product_id = '414929'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414929'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414929')

SELECT *
FROM product_image
WHERE product_id = '414878'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414878'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414878')

SELECT *
FROM product_image
WHERE product_id = '414883'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414883'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414883')

SELECT *
FROM product_image
WHERE product_id = '414937'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414937'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414937')

SELECT *
FROM product_image
WHERE product_id = '414887'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414887'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414887')

SELECT *
FROM product_image
WHERE product_id = '414892'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414892'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414892')

SELECT *
FROM product_image
WHERE product_id = '414911'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414911'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414911')

SELECT *
FROM product_image
WHERE product_id = '414919'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414919'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414919')

SELECT *
FROM product_image
WHERE product_id = '414864'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414864'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414864')

SELECT *
FROM product_image
WHERE product_id = '414875'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414875'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414875')

SELECT *
FROM product_image
WHERE product_id = '72599'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72599'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=72599')

SELECT *
FROM product_image
WHERE product_id = '72329'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72329'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=72329')

SELECT *
FROM product_image
WHERE product_id = '72596'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72596'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=72596')

SELECT *
FROM product_image
WHERE product_id = '405798'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405798'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=405798')

SELECT *
FROM product_image
WHERE product_id = '72602'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72602'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=72602')

SELECT *
FROM product_image
WHERE product_id = '414934'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414934'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414934')

SELECT *
FROM product_image
WHERE product_id = '405805'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405805'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=405805')

SELECT *
FROM product_image
WHERE product_id = '72666'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72666'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=72666')

SELECT *
FROM product_image
WHERE product_id = '72670'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72670'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=72670')

SELECT *
FROM product_image
WHERE product_id = '405755'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405755'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=405755')

SELECT *
FROM product_image
WHERE product_id = '2019'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '2019'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=2019')

SELECT *
FROM product_image
WHERE product_id = '414896'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414896'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414896')

SELECT *
FROM product_image
WHERE product_id = '405765'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405765'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=405765')

SELECT *
FROM product_image
WHERE product_id = '22074'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '22074'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=22074')

SELECT *
FROM product_image
WHERE product_id = '414903'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414903'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414903')

SELECT *
FROM product_image
WHERE product_id = '405768'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405768'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=405768')

SELECT *
FROM product_image
WHERE product_id = '414907'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414907'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414907')

SELECT *
FROM product_image
WHERE product_id = '405774'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405774'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=405774')

SELECT *
FROM product_image
WHERE product_id = '72332'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72332'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=72332')

SELECT *
FROM product_image
WHERE product_id = '405780'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405780'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=405780')

SELECT *
FROM product_image
WHERE product_id = '72336'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '72336'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=72336')

SELECT *
FROM product_image
WHERE product_id = '405792'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405792'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=405792')

SELECT *
FROM product_image
WHERE product_id = '414925'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '414925'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=414925')

SELECT *
FROM product_image
WHERE product_id = '405796'
ORDER BY sort_order ASC

SELECT *
FROM product_option po
LEFT JOIN `option` o ON (po.option_id = o.option_id)
WHERE po.product_id = '405796'
ORDER BY o.sort_order

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924', 'product_id=405796')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM category_to_layout
WHERE category_id = '924' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT *
FROM category_to_layout
WHERE category_id = '924' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT a.name, a.attribute_id,pa.attribute_value_id
FROM attribute a
LEFT JOIN product_attribute pa on pa.attribute_id=a.attribute_id
WHERE a.use_in_filter='1' and pa.store_id='0' and pa.product_id IN('2019','22074','72329','72332','72336','72596','72599','72602','72666','72670','405755','405765','405768','405774','405780','405792','405796','405798','405805','411105','414657','414667','414704','414705','414714','414719','414864','414875','414878','414883','414887','414892','414896','414903','414907','414911','414919','414925','414929','414934','414937','414948','414962','414964','414967','414976','414986','415047') group by a.attribute_id

SELECT (IF(min(ps.price)>0 and min(ps.price)as min, (IF(max(ps.price)>0 and max(ps.price)>max(p.price),max(ps.price),Max( p.price ))) as max
FROM product p
LEFT JOIN product_special ps on ps.product_id=p.product_id
LEFT JOIN product_to_store p2s on p2s.product_id=p.product_id
left join manufacturer m on m.manufacturer_id=p.manufacturer_id
where p.product_id IN('2019','22074','72329','72332','72336','72596','72599','72602','72666','72670','405755','405765','405768','405774','405780','405792','405796','405798','405805','411105','414657','414667','414704','414705','414714','414719','414864','414875','414878','414883','414887','414892','414896','414903','414907','414911','414919','414925','414929','414934','414937','414948','414962','414964','414967','414976','414986','415047') and p2s.status = '1' and p2s.store_id='0'

SELECT (IF(min(ps.price)>0 and min(ps.price)as min, (IF(max(ps.price)>0 and max(ps.price)>max(p.price),max(ps.price),Max( p.price ))) as max
FROM product p
LEFT JOIN product_special ps on ps.product_id=p.product_id
LEFT JOIN product_to_store p2s on p2s.product_id=p.product_id
left join manufacturer m on m.manufacturer_id=p.manufacturer_id
where p.product_id IN('2019','22074','72329','72332','72336','72596','72599','72602','72666','72670','405755','405765','405768','405774','405780','405792','405796','405798','405805','411105','414657','414667','414704','414705','414714','414719','414864','414875','414878','414883','414887','414892','414896','414903','414907','414911','414919','414925','414929','414934','414937','414948','414962','414964','414967','414976','414986','415047') and p2s.status = '1' and p2s.store_id='0'

SELECT *
FROM category c
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c2s.store_id = '0' AND c.status = '1' AND c.top='1'
ORDER BY c.parent_id, c.sort_order, c.name

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=935')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=935')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=935')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=935')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=935')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=935')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM category_to_layout
WHERE category_id = '924' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT *
FROM category_to_layout
WHERE category_id = '924' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT DISTINCT layout_id
FROM layout_route
where store_id='0' AND route='product/category'

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='924' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top' and b.slider='0' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='924' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top' and b.slider='1' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT MAX(bi.width) as width,MAX(bi.height) as height
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='924' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top' and slider='1' and bi.status='1' and b.status='1'

SELECT *
FROM category_to_layout
WHERE category_id = '924' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT DISTINCT layout_id
FROM layout_route
where store_id='0' AND route='product/category'

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='924' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top_left' and b.slider='0' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='924' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top_left' and b.slider='1' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT MAX(bi.width) as width,MAX(bi.height) as height
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='924' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='header_top_left' and slider='1' and bi.status='1' and b.status='1'

SELECT *
FROM category_to_layout
WHERE category_id = '924' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT DISTINCT layout_id
FROM layout_route
where store_id='0' AND route='product/category'

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='924' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='content_top' and b.slider='0' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT b.slider,b.slider_arrow,b.slider_button,bi.link,bi.image,bi.width,bi.height,bi.name
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='924' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='content_top' and b.slider='1' and bi.status='1' and b.status='1'
ORDER BY b.sort_order

SELECT MAX(bi.width) as width,MAX(bi.height) as height
FROM banner_advanced_parts b
left join banner_advanced_image bi on bi.banner_advanced_image_id=b.banner_advanced_image_id
where b.layout_id='3' and b.part_id='924' and b.store_id='0' and (((bi.date_start<=CURDATE() or bi.date_start='0000-00-00') and (bi.date_end>=CURDATE() or bi.date_end='0000-00-00')) or (bi.date_start='0000-00-00' and bi.date_end='0000-00-00')) and b.position='content_top' and slider='1' and bi.status='1' and b.status='1'

SELECT *
FROM category_to_layout
WHERE category_id = '924' AND store_id = '0'

SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1

SELECT *
FROM extension
WHERE `type` = 'module'

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=106')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=13')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=935')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=922')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=923')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=925')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=926')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=927')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=928')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=929')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=935')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=932')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=934')

SELECT *
FROM information i
LEFT JOIN information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE i2s.store_id = '0' AND i.top = '1' AND i.status = '1' AND i.sort_order <> '-1'
ORDER BY i.sort_order, LCASE(i.title) ASC

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=37')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=35')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=8')

SELECT *
FROM url_alias
WHERE `query` IN ('information_id=9')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM url_alias
WHERE `query` IN ('category_id=924')

SELECT *
FROM extension
WHERE `type` = 'total'

SELECT *
FROM extension
WHERE `type` = 'total'