VP Laboratory Ultimate Recovery

SELECT * FROM op_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://atlet40.ru/'

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

SELECT * FROM op_language WHERE STATUS = '1'

SELECT * FROM op_currency

SELECT * FROM op_weight_class wc LEFT JOIN op_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'

SELECT * FROM op_length_class mc LEFT JOIN op_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'

SELECT f1.postalcode f1_postalcode, CONCAT(f1.shortname, ' ', f1.offname) f1_name,
                                            f1.level f1_level, f1.fias_id f1_fias_id, f1.shortname f1_shortname,
                                          CONCAT(f2.offname, ' ', f2.shortname) f2_name,
                                            f2.level f2_level, f2.fias_id f2_fias_id,
                                          CONCAT(f3.offname, ' ', f3.shortname) f3_name,
                                            f3.level f3_level, f3.fias_id f3_fias_id,
                                          CONCAT(f4.offname, ' ', f4.shortname) f4_name,
                                            f4.level f4_level, f4.fias_id f4_fias_id
                                      FROM fias f1
                                        LEFT JOIN fias f2 ON f2.fias_id = f1.parent_id
                                        LEFT JOIN fias f3 ON f3.fias_id = f2.parent_id
                                        LEFT JOIN fias f4 ON f4.fias_id = f3.parent_id
                                      WHERE f1.offname = 'Woodbridge'
                                        AND (f3.offname = 'США' OR f2.offname = 'США' OR f4.offname = 'США')
                                        AND (f1.level = 4 OR (f1.level = 1 AND f1.shortname = 'г.'))

SELECT *
                                        FROM op_country c
                                        WHERE c.iso_code_2 = "US"

SELECT code FROM geoip_currency WHERE country_id = 0

SELECT * FROM geoip_rule

SELECT * FROM geoip_redirect

SELECT `value` FROM `op_setting` WHERE `key` = 'config_language'

SELECT * FROM op_language WHERE STATUS = '1'

SELECT * FROM op_url_alias WHERE keyword IN ('specialnye-preparaty', 'vosstanoviteli', 'vp-ultimate-recovery')

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '606'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=606') ORDER BY `keyword` ASC

SELECT * FROM op_category c LEFT JOIN op_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN op_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE cd.language_id = '1' AND c2s.store_id = '0' AND c.STATUS = '1' ORDER BY c.parent_id, c.sort_order, cd.name

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '39'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '41'

SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM op_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM op_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM op_product_reward pr WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name FROM op_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM op_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM op_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM op_review r1 WHERE r1.product_id = p.product_id AND r1.STATUS = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM op_review r2 WHERE r2.product_id = p.product_id AND r2.STATUS = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '606' AND pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '606'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=606') ORDER BY `keyword` ASC

SELECT cd.name FROM op_category_description cd LEFT JOIN op_product_to_category pc ON(pc.category_id=cd.category_id) WHERE pc.product_id='606'

SELECT m.name FROM op_manufacturer m LEFT JOIN op_product p ON(p.manufacturer_id=m.manufacturer_id) WHERE p.product_id='606'

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '606'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=606') ORDER BY `keyword` ASC

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '606'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=606') ORDER BY `keyword` ASC

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 606
 

SELECT RO.relatedoptions_id, PO.product_option_id, POV.product_option_value_id
                                FROM op_relatedoptions RO
                                    ,op_relatedoptions_option ROO
                                    ,op_product_option PO
                                    ,op_product_option_value POV
                                WHERE RO.product_id = 606
																	AND RO.quantity > 0
                                  AND PO.product_id = 606
                                  AND POV.product_id = 606
                                  AND RO.relatedoptions_id = ROO.relatedoptions_id
                                  AND ROO.option_id = PO.option_id
                                  AND ROO.option_value_id = POV.option_value_id
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 606
 

SELECT RO.relatedoptions_id, PO.product_option_id, POV.product_option_value_id
                                FROM op_relatedoptions RO
                                    ,op_relatedoptions_option ROO
                                    ,op_product_option PO
                                    ,op_product_option_value POV
                                WHERE RO.product_id = 606
																	AND RO.quantity = 0
                                  AND PO.product_id = 606
                                  AND POV.product_id = 606
                                  AND RO.relatedoptions_id = ROO.relatedoptions_id
                                  AND ROO.option_id = PO.option_id
                                  AND ROO.option_value_id = POV.option_value_id
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 606
 

	SELECT VP.relatedoptions_variant_id
																FROM 	op_relatedoptions_variant_product VP
																WHERE VP.product_id = 606
 

	SELECT VO.option_id
																	FROM `op_relatedoptions_variant_option` VO
																	WHERE relatedoptions_variant_id = 3
 

SELECT PO.product_option_id
                                    FROM  op_product_option PO
                                    WHERE PO.option_id IN (4,6)
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 606
 

SELECT RO.relatedoptions_id, RO.price ro_price, ROD.price, ROD.quantity, RO.model, RO.description, RO.quantity
															FROM op_relatedoptions RO
															LEFT JOIN op_relatedoptions_discount ROD ON (RO.relatedoptions_id = ROD.relatedoptions_id && ROD.customer_group_id = 1 )
															WHERE RO.product_id = 606
 

SELECT ROD.*
															FROM op_relatedoptions_special ROD, op_relatedoptions RO
															WHERE RO.product_id = 606
																AND RO.relatedoptions_id = ROD.relatedoptions_id
																AND ROD.customer_group_id = 1
															ORDER BY ROD.priority ASC, ROD.price ASC	
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 606
 

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

SHOW TABLES LIKE "op_relatedoptions"

SHOW TABLES LIKE "op_relatedoptions_variant_product"

SHOW COLUMNS FROM `op_relatedoptions_variant_product` WHERE FIELD='relatedoptions_use'

SHOW TABLES LIKE "op_relatedoptions_discount"

	SELECT VP.relatedoptions_use
																FROM 	`op_relatedoptions_variant_product` VP
																WHERE	VP.product_id = 606
 

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '606'

SELECT COUNT(*) AS total FROM op_review r LEFT JOIN op_product p ON (r.product_id = p.product_id) LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id IN (606) AND p.date_available <= NOW() AND p.STATUS = '1' AND r.STATUS = '1' AND pd.language_id = '1'

SELECT op_category_description.name
			FROM
			op_product_to_category
			INNER JOIN op_category_description
			ON op_product_to_category.category_id = op_category_description.category_id
			WHERE
			op_product_to_category.product_id = 606
			AND op_category_description.language_id = 1
			AND op_product_to_category.main_category = 1

SELECT * FROM op_product_image WHERE product_id = '606' ORDER BY sort_order ASC

SELECT * FROM op_product_discount WHERE product_id = '606' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC

SELECT * FROM op_product_option po LEFT JOIN `op_option` o ON (po.option_id = o.option_id) LEFT JOIN op_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '606' AND od.language_id = '1' ORDER BY o.sort_order

SELECT * FROM op_product_option_value pov LEFT JOIN op_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN op_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '606' AND pov.product_option_id = '109352' AND ovd.language_id = '1' ORDER BY pov.quantity DESC, ov.sort_order

SELECT * FROM op_product_option_value pov LEFT JOIN op_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN op_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '606' AND pov.product_option_id = '109353' AND ovd.language_id = '1' ORDER BY pov.quantity DESC, ov.sort_order

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '606'

SELECT COUNT(*) AS total FROM op_review r LEFT JOIN op_product p ON (r.product_id = p.product_id) LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id IN (606) AND p.date_available <= NOW() AND p.STATUS = '1' AND r.STATUS = '1' AND pd.language_id = '1'

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '606'

SELECT DISTINCT ag.attribute_group_id, agd.name FROM op_product_attribute pa LEFT JOIN op_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN op_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN op_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id IN (606) AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name

SELECT DISTINCT a.attribute_id, ad.name, pa.text, pa.rdn FROM op_product_attribute pa LEFT JOIN op_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN op_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id IN (606) AND a.attribute_group_id = '1' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name

SELECT * FROM op_product_related pr LEFT JOIN op_product p ON (pr.related_id = p.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '606' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'

UPDATE op_product SET viewed = (viewed + 1) WHERE product_id = '606'

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '606'

SELECT DISTINCT p.product_id,
		                                           p.price,
												   p.purchase_price,
												   p.image,
		                                           pd.tag,
		                                           p.quantity,
		                                           (SELECT price FROM op_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount,
		                                           (SELECT price FROM op_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
                                 FROM op_product p
                                 LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id)
                                 LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id)
                                 LEFT JOIN op_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
                               WHERE p.product_id IN (606)
                                 AND pd.language_id = '1'
                                 AND p.STATUS = '1'
                                 AND p.date_available <= NOW()
                                 AND p2s.store_id = '0'

SELECT * FROM op_product_option po LEFT JOIN `op_option` o ON (po.option_id = o.option_id) LEFT JOIN op_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '606' AND od.language_id = '1' ORDER BY o.sort_order

SELECT * FROM op_product_option_value pov LEFT JOIN op_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN op_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '606' AND pov.product_option_id = '109352' AND ovd.language_id = '1' ORDER BY pov.quantity DESC, ov.sort_order

SELECT * FROM op_product_option_value pov LEFT JOIN op_option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN op_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_id = '606' AND pov.product_option_id = '109353' AND ovd.language_id = '1' ORDER BY pov.quantity DESC, ov.sort_order

SELECT * FROM op_customer_group WHERE customer_group_id = '1' LIMIT 1

 
			SELECT rating,`type` FROM op_review
			WHERE
				`type` != '' AND product_id IN (606)

SELECT op_news_description.*, op_news.*
 
									FROM op_news
									INNER JOIN op_news_description
									ON op_news.news_id = op_news_description.news_id
									WHERE op_news.STATUS = 1
									  AND op_news_description.language_id = 1
									ORDER BY   op_news_description.news_id DESC
									LIMIT 3
 

SELECT op_review.*, op_product_description.name AS pname
									FROM op_review
									INNER JOIN op_product_description
									ON op_product_description.product_id = op_review.product_id
									WHERE op_review.STATUS = 1
									 AND op_product_description.language_id = 1
									ORDER BY `review_id` DESC LIMIT 3
 

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1323'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1323') ORDER BY `keyword` ASC

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '210'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=208','product_id=209','product_id=210','product_id=719') ORDER BY `keyword` ASC

SELECT pd1.product_id FROM op_product p JOIN op_product_description pd ON pd.product_id = p.product_id JOIN op_product p1 ON p1.manufacturer_id = p.manufacturer_id JOIN op_product_description pd1 ON pd1.name = pd.name AND pd1.product_id = p1.product_id WHERE p.product_id = '1273'

SELECT * FROM op_url_alias WHERE `query` IN ('product_id=1273') ORDER BY `keyword` ASC

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '49'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '59'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '62'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '52'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '57'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '53'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '56'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '54'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '61'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '50'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '51'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '63'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '2'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '3'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '1'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '5'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '6'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '7'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '8'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '9'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '10'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '4'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '11'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '13'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '14'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '15'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '12'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '16'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '18'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '48'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '17'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '19'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '21'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '55'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '22'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '23'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '20'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '58'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '25'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '26'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '27'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '24'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '29'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '30'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '31'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '32'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '28'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '44'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '34'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '36'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '60'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '35'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '37'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '33'

SELECT COUNT(DISTINCT p.product_id) AS total FROM op_product p LEFT JOIN op_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN op_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN op_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE pd.language_id = '1' AND p.STATUS = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (64)

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '64'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '38'

SELECT CONCAT_WS('_',t9.category_id,t8.category_id,t7.category_id,t6.category_id,t5.category_id,t4.category_id,t3.category_id,t2.category_id,t1.category_id,t0.category_id) AS path FROM op_category t0 LEFT JOIN op_category t1 ON (t1.category_id = t0.parent_id) LEFT JOIN op_category t2 ON (t2.category_id = t1.parent_id) LEFT JOIN op_category t3 ON (t3.category_id = t2.parent_id) LEFT JOIN op_category t4 ON (t4.category_id = t3.parent_id) LEFT JOIN op_category t5 ON (t5.category_id = t4.parent_id) LEFT JOIN op_category t6 ON (t6.category_id = t5.parent_id) LEFT JOIN op_category t7 ON (t7.category_id = t6.parent_id) LEFT JOIN op_category t8 ON (t8.category_id = t7.parent_id) LEFT JOIN op_category t9 ON (t9.category_id = t8.parent_id) WHERE t0.category_id = '40'