SELECT S.ID_SHOP, CONCAT(SU.PHYSICAL_URI, SU.VIRTUAL_URI) AS URI, SU.DOMAIN, SU.MAIN
                    FROM NBBL_SHOP_URL SU
                    LEFT JOIN NBBL_SHOP S ON (S.ID_SHOP = SU.ID_SHOP)
                    WHERE (SU.DOMAIN = 'WWW.BOBOLI.IE' OR SU.DOMAIN_SSL = 'WWW.BOBOLI.IE')
                        AND S.ACTIVE = 1
                        AND S.DELETED = 0
                    ORDER BY LENGTH(CONCAT(SU.PHYSICAL_URI, SU.VIRTUAL_URI)) DESC0
SELECT GS.*, S.*, GS.NAME AS GROUP_NAME, S.NAME AS SHOP_NAME, S.ACTIVE, SU.DOMAIN, SU.DOMAIN_SSL, SU.PHYSICAL_URI, SU.VIRTUAL_URI
                FROM NBBL_SHOP_GROUP GS
                LEFT JOIN NBBL_SHOP S
                    ON S.ID_SHOP_GROUP = GS.ID_SHOP_GROUP
                LEFT JOIN NBBL_SHOP_URL SU
                    ON S.ID_SHOP = SU.ID_SHOP AND SU.MAIN = 1
                
                WHERE S.DELETED = 0
                    AND GS.DELETED = 0
                    
                ORDER BY GS.NAME, S.NAME0
SELECT VALUE FROM `NBBL_CONFIGURATION` WHERE `NAME` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 10
SELECT COUNT(*) FROM NBBL_SHOP LIMIT 10
SELECT *
FROM `NBBL_SHOP` A
WHERE (A.`ID_SHOP` = 22) LIMIT 10
SELECT SU.PHYSICAL_URI, SU.VIRTUAL_URI, SU.DOMAIN, SU.DOMAIN_SSL
              FROM NBBL_SHOP S
              LEFT JOIN NBBL_SHOP_URL SU ON (S.ID_SHOP = SU.ID_SHOP)
              WHERE S.ID_SHOP = 22
              AND S.ACTIVE = 1 AND S.DELETED = 0 AND SU.MAIN = 1 LIMIT 10
SELECT L.*, LS.`ID_SHOP`
				FROM `NBBL_LANG` L
				LEFT JOIN `NBBL_LANG_SHOP` LS ON (L.ID_LANG = LS.ID_LANG)0
SELECT *
FROM `NBBL_COUNTRY` A
LEFT JOIN `NBBL_COUNTRY_LANG` `B` ON A.`ID_COUNTRY` = B.`ID_COUNTRY` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_COUNTRY_SHOP` `C` ON A.`ID_COUNTRY` = C.`ID_COUNTRY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_COUNTRY` = 26) LIMIT 10
SELECT *
FROM `NBBL_SHOP_GROUP` A
WHERE (A.`ID_SHOP_GROUP` = 1) LIMIT 10
SELECT *
FROM `NBBL_LANG` A
LEFT JOIN `NBBL_LANG_SHOP` `C` ON A.`ID_LANG` = C.`ID_LANG` AND C.`ID_SHOP` = 22
WHERE (A.`ID_LANG` = 1) LIMIT 10
SELECT ID_SHOP
				FROM `NBBL_LANG_SHOP`
				WHERE `ID_LANG` = 1
				AND ID_SHOP = 22 LIMIT 10
SELECT DOMAIN, DOMAIN_SSL
            FROM NBBL_SHOP_URL
            WHERE MAIN = 1
            AND ID_SHOP = 22 LIMIT 10
SELECT COUNT(DISTINCT L.ID_LANG) FROM `NBBL_LANG` L
				JOIN NBBL_LANG_SHOP LANG_SHOP ON (LANG_SHOP.ID_LANG = L.ID_LANG AND LANG_SHOP.ID_SHOP = 22)
				WHERE L.`ACTIVE` = 1 LIMIT 10
SELECT `ID_LANG`, IF(LANGUAGE_CODE = 'EN-US', 0, LENGTH(LANGUAGE_CODE)) AS FOUND
			FROM `NBBL_LANG`
			WHERE LEFT(`LANGUAGE_CODE`,2) = 'EN'
			ORDER BY FOUND ASC LIMIT 10
SELECT LOWER(NAME) AS NAME
FROM `NBBL_HOOK` H
WHERE (H.ACTIVE = 1)0
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "DELUXEPRIVATESHOP" LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE_SHOP` WHERE `ID_MODULE` = 0 AND `ID_SHOP` = 22 LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "IDXPRIVATESHOP" LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE_SHOP` WHERE `ID_MODULE` = 0 AND `ID_SHOP` = 22 LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "EXTENDEDREGISTRATION" LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE_SHOP` WHERE `ID_MODULE` = 0 AND `ID_SHOP` = 22 LIMIT 10
SELECT `NAME`, `ALIAS` FROM `NBBL_HOOK_ALIAS`0
SELECT `ID_HOOK`, `NAME` FROM `NBBL_HOOK`0
SELECT M.`ID_MODULE`, M.`NAME`, MS.`ID_MODULE`AS `MSHOP`
                FROM `NBBL_MODULE` M
                LEFT JOIN `NBBL_MODULE_SHOP` MS
                ON M.`ID_MODULE` = MS.`ID_MODULE`
                AND MS.`ID_SHOP` = 220
SELECT NAME, ALIAS FROM `NBBL_HOOK_ALIAS`0
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "PAGECACHE" LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE_SHOP` WHERE `ID_MODULE` = 218 AND `ID_SHOP` = 22 LIMIT 10
SELECT M.PAGE, ML.URL_REWRITE, ML.ID_LANG
					FROM `NBBL_META` M
					LEFT JOIN `NBBL_META_LANG` ML ON (M.ID_META = ML.ID_META AND ML.ID_SHOP = 22 )
					ORDER BY LENGTH(ML.URL_REWRITE) DESC0
SELECT * FROM `NBBL_HOOK_MODULE_EXCEPTIONS`
                WHERE `ID_SHOP` IN (22)0
SELECT M.`ID_MODULE`, M.`NAME`, MS.`ID_MODULE`AS `MSHOP`
                FROM `NBBL_MODULE` M
                LEFT JOIN `NBBL_MODULE_SHOP` MS
                ON M.`ID_MODULE` = MS.`ID_MODULE`
                AND MS.`ID_SHOP` = 220
SELECT M.`ID_MODULE`, M.`NAME`, MS.`ID_MODULE`AS `MSHOP`
                FROM `NBBL_MODULE` M
                LEFT JOIN `NBBL_MODULE_SHOP` MS
                ON M.`ID_MODULE` = MS.`ID_MODULE`
                AND MS.`ID_SHOP` = 220
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "BVKSEODISPATCHER" LIMIT 10
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_LANG` `B` ON A.`ID_CATEGORY` = B.`ID_CATEGORY` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_CATEGORY` = 877) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "BBLCOVERENHANCED" LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE_SHOP` WHERE `ID_MODULE` = 192 AND `ID_SHOP` = 22 LIMIT 10
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_CATEGORY` = 877) LIMIT 10
SELECT *
							FROM `NBBL_CATEGORY_LANG`
							WHERE `ID_CATEGORY` = 877 AND `ID_SHOP` = 220
SELECT * FROM NBBL_CATEGORY_SEO_REDIRECTS WHERE ID_CATEGORY = 877 LIMIT 10
SELECT `ID_LANG` FROM `NBBL_LANG`
                    WHERE `LOCALE` = 'EN-US'
                    OR `LANGUAGE_CODE` = 'EN-US' LIMIT 10
SELECT *
FROM `NBBL_CURRENCY` A
LEFT JOIN `NBBL_CURRENCY_LANG` `B` ON A.`ID_CURRENCY` = B.`ID_CURRENCY` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_CURRENCY_SHOP` `C` ON A.`ID_CURRENCY` = C.`ID_CURRENCY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_CURRENCY` = 1) LIMIT 10
SELECT `ID_LANG` FROM `NBBL_LANG`
                    WHERE `LOCALE` = 'EN-US'
                    OR `LANGUAGE_CODE` = 'EN-US' LIMIT 10
SELECT `ID_LANG` FROM `NBBL_LANG`
                    WHERE `LOCALE` = 'EN-US'
                    OR `LANGUAGE_CODE` = 'EN-US' LIMIT 10
SELECT *
FROM `NBBL_CURRENCY` A
LEFT JOIN `NBBL_CURRENCY_LANG` `B` ON A.`ID_CURRENCY` = B.`ID_CURRENCY` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_CURRENCY_SHOP` `C` ON A.`ID_CURRENCY` = C.`ID_CURRENCY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_CURRENCY` = 2) LIMIT 10
SELECT `ID_LANG` FROM `NBBL_LANG`
                    WHERE `LOCALE` = 'EN-US'
                    OR `LANGUAGE_CODE` = 'EN-US' LIMIT 10
SELECT *
FROM `NBBL_CURRENCY` A
LEFT JOIN `NBBL_CURRENCY_SHOP` `C` ON A.`ID_CURRENCY` = C.`ID_CURRENCY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_CURRENCY` = 1) LIMIT 10
SELECT *
							FROM `NBBL_CURRENCY_LANG`
							WHERE `ID_CURRENCY` = 10
SELECT ID_SHOP
				FROM `NBBL_CURRENCY_SHOP`
				WHERE `ID_CURRENCY` = 1
				AND ID_SHOP = 22 LIMIT 10
SELECT *
FROM `NBBL_GROUP` A
LEFT JOIN `NBBL_GROUP_SHOP` `C` ON A.`ID_GROUP` = C.`ID_GROUP` AND C.`ID_SHOP` = 22
WHERE (A.`ID_GROUP` = 1) LIMIT 10
SELECT *
							FROM `NBBL_GROUP_LANG`
							WHERE `ID_GROUP` = 10
SELECT ID_SHOP
				FROM `NBBL_GROUP_SHOP`
				WHERE `ID_GROUP` = 1
				AND ID_SHOP = 22 LIMIT 10
SELECT *
FROM `NBBL_CURRENCY` A
LEFT JOIN `NBBL_CURRENCY_SHOP` `C` ON A.`ID_CURRENCY` = C.`ID_CURRENCY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_CURRENCY` = 1) LIMIT 10
SELECT *
							FROM `NBBL_CURRENCY_LANG`
							WHERE `ID_CURRENCY` = 10
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "FACEBOOKPRODUCTSFEED" LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE_SHOP` WHERE `ID_MODULE` = 0 AND `ID_SHOP` = 22 LIMIT 10
SELECT DISTINCT G.ID_TAX_RULES_GROUP, G.NAME, G.ACTIVE FROM `NBBL_TAX_RULES_GROUP` G INNER JOIN NBBL_TAX_RULES_GROUP_SHOP TAX_RULES_GROUP_SHOP
        ON (TAX_RULES_GROUP_SHOP.ID_TAX_RULES_GROUP = G.ID_TAX_RULES_GROUP AND TAX_RULES_GROUP_SHOP.ID_SHOP = 22) WHERE G.DELETED = 0 AND G.`ACTIVE` = 1 ORDER BY NAME ASC0
SELECT `ID_HOOK`, `NAME`
                FROM `NBBL_HOOK`
                UNION
                SELECT `ID_HOOK`, HA.`ALIAS` AS NAME
                FROM `NBBL_HOOK_ALIAS` HA
                INNER JOIN `NBBL_HOOK` H ON HA.NAME = H.NAME0
SELECT TR.*
				FROM `NBBL_TAX_RULE` TR
				JOIN `NBBL_TAX_RULES_GROUP` TRG ON (TR.`ID_TAX_RULES_GROUP` = TRG.`ID_TAX_RULES_GROUP`)
				WHERE TRG.`ACTIVE` = 1
				AND TR.`ID_COUNTRY` = 26
				AND TR.`ID_TAX_RULES_GROUP` = 25
				AND TR.`ID_STATE` IN (0, 0)
				AND ('0' BETWEEN TR.`ZIPCODE_FROM` AND TR.`ZIPCODE_TO`
					OR (TR.`ZIPCODE_TO` = 0 AND TR.`ZIPCODE_FROM` IN(0, '0')))
				ORDER BY TR.`ZIPCODE_FROM` DESC, TR.`ZIPCODE_TO` DESC, TR.`ID_STATE` DESC, TR.`ID_COUNTRY` DESC0
SELECT *
FROM `NBBL_TAX` A
WHERE (A.`ID_TAX` = 44) LIMIT 10
SELECT *
							FROM `NBBL_TAX_LANG`
							WHERE `ID_TAX` = 440
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "PS_LEGALCOMPLIANCE" LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE_SHOP` WHERE `ID_MODULE` = 0 AND `ID_SHOP` = 22 LIMIT 10
SELECT * FROM `NBBL_IMAGE_TYPE` WHERE 1 AND `PRODUCTS` = 1  ORDER BY `WIDTH` DESC, `HEIGHT` DESC, `NAME`ASC0
SELECT FORMAT
			FROM `NBBL_ADDRESS_FORMAT`
			WHERE `ID_COUNTRY` = 6 LIMIT 10
SELECT `NEED_IDENTIFICATION_NUMBER`
			FROM `NBBL_COUNTRY`
			WHERE `ID_COUNTRY` = 6 LIMIT 10
SELECT *
FROM `NBBL_COUNTRY` A
LEFT JOIN `NBBL_COUNTRY_SHOP` `C` ON A.`ID_COUNTRY` = C.`ID_COUNTRY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_COUNTRY` = 6) LIMIT 10
SELECT *
							FROM `NBBL_COUNTRY_LANG`
							WHERE `ID_COUNTRY` = 60
SELECT ID_REQUIRED_FIELD, OBJECT_NAME, FIELD_NAME
		FROM NBBL_REQUIRED_FIELD0
SELECT *
FROM `NBBL_COUNTRY` A
LEFT JOIN `NBBL_COUNTRY_SHOP` `C` ON A.`ID_COUNTRY` = C.`ID_COUNTRY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_COUNTRY` = 3) LIMIT 10
SELECT *
							FROM `NBBL_COUNTRY_LANG`
							WHERE `ID_COUNTRY` = 30
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_LANG` `B` ON A.`ID_CATEGORY` = B.`ID_CATEGORY` AND B.`ID_LANG` = 5
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 19
WHERE (A.`ID_CATEGORY` = 877) AND (B.`ID_SHOP` = 19) LIMIT 10
SELECT *
FROM `NBBL_SHOP` A
WHERE (A.`ID_SHOP` = 19) LIMIT 10
SELECT SU.PHYSICAL_URI, SU.VIRTUAL_URI, SU.DOMAIN, SU.DOMAIN_SSL
              FROM NBBL_SHOP S
              LEFT JOIN NBBL_SHOP_URL SU ON (S.ID_SHOP = SU.ID_SHOP)
              WHERE S.ID_SHOP = 19
              AND S.ACTIVE = 1 AND S.DELETED = 0 AND SU.MAIN = 1 LIMIT 10
SELECT COUNT(DISTINCT L.ID_LANG) FROM `NBBL_LANG` L
				JOIN NBBL_LANG_SHOP LANG_SHOP ON (LANG_SHOP.ID_LANG = L.ID_LANG AND LANG_SHOP.ID_SHOP = 19)
				WHERE L.`ACTIVE` = 1 LIMIT 10
SELECT M.PAGE, ML.URL_REWRITE, ML.ID_LANG
					FROM `NBBL_META` M
					LEFT JOIN `NBBL_META_LANG` ML ON (M.ID_META = ML.ID_META AND ML.ID_SHOP = 19 )
					ORDER BY LENGTH(ML.URL_REWRITE) DESC0
SELECT *
FROM `NBBL_COUNTRY` A
LEFT JOIN `NBBL_COUNTRY_SHOP` `C` ON A.`ID_COUNTRY` = C.`ID_COUNTRY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_COUNTRY` = 1) LIMIT 10
SELECT *
							FROM `NBBL_COUNTRY_LANG`
							WHERE `ID_COUNTRY` = 10
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_LANG` `B` ON A.`ID_CATEGORY` = B.`ID_CATEGORY` AND B.`ID_LANG` = 6
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 21
WHERE (A.`ID_CATEGORY` = 877) AND (B.`ID_SHOP` = 21) LIMIT 10
SELECT *
FROM `NBBL_SHOP` A
WHERE (A.`ID_SHOP` = 21) LIMIT 10
SELECT SU.PHYSICAL_URI, SU.VIRTUAL_URI, SU.DOMAIN, SU.DOMAIN_SSL
              FROM NBBL_SHOP S
              LEFT JOIN NBBL_SHOP_URL SU ON (S.ID_SHOP = SU.ID_SHOP)
              WHERE S.ID_SHOP = 21
              AND S.ACTIVE = 1 AND S.DELETED = 0 AND SU.MAIN = 1 LIMIT 10
SELECT COUNT(DISTINCT L.ID_LANG) FROM `NBBL_LANG` L
				JOIN NBBL_LANG_SHOP LANG_SHOP ON (LANG_SHOP.ID_LANG = L.ID_LANG AND LANG_SHOP.ID_SHOP = 21)
				WHERE L.`ACTIVE` = 1 LIMIT 10
SELECT M.PAGE, ML.URL_REWRITE, ML.ID_LANG
					FROM `NBBL_META` M
					LEFT JOIN `NBBL_META_LANG` ML ON (M.ID_META = ML.ID_META AND ML.ID_SHOP = 21 )
					ORDER BY LENGTH(ML.URL_REWRITE) DESC0
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_LANG` `B` ON A.`ID_CATEGORY` = B.`ID_CATEGORY` AND B.`ID_LANG` = 3
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 1
WHERE (A.`ID_CATEGORY` = 877) AND (B.`ID_SHOP` = 1) LIMIT 10
SELECT *
FROM `NBBL_SHOP` A
WHERE (A.`ID_SHOP` = 1) LIMIT 10
SELECT SU.PHYSICAL_URI, SU.VIRTUAL_URI, SU.DOMAIN, SU.DOMAIN_SSL
              FROM NBBL_SHOP S
              LEFT JOIN NBBL_SHOP_URL SU ON (S.ID_SHOP = SU.ID_SHOP)
              WHERE S.ID_SHOP = 1
              AND S.ACTIVE = 1 AND S.DELETED = 0 AND SU.MAIN = 1 LIMIT 10
SELECT COUNT(DISTINCT L.ID_LANG) FROM `NBBL_LANG` L
				JOIN NBBL_LANG_SHOP LANG_SHOP ON (LANG_SHOP.ID_LANG = L.ID_LANG AND LANG_SHOP.ID_SHOP = 1)
				WHERE L.`ACTIVE` = 1 LIMIT 10
SELECT M.PAGE, ML.URL_REWRITE, ML.ID_LANG
					FROM `NBBL_META` M
					LEFT JOIN `NBBL_META_LANG` ML ON (M.ID_META = ML.ID_META AND ML.ID_SHOP = 1 )
					ORDER BY LENGTH(ML.URL_REWRITE) DESC0
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_LANG` `B` ON A.`ID_CATEGORY` = B.`ID_CATEGORY` AND B.`ID_LANG` = 9
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 1
WHERE (A.`ID_CATEGORY` = 877) AND (B.`ID_SHOP` = 1) LIMIT 10
SELECT *
FROM `NBBL_COUNTRY` A
LEFT JOIN `NBBL_COUNTRY_SHOP` `C` ON A.`ID_COUNTRY` = C.`ID_COUNTRY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_COUNTRY` = 8) LIMIT 10
SELECT *
							FROM `NBBL_COUNTRY_LANG`
							WHERE `ID_COUNTRY` = 80
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_LANG` `B` ON A.`ID_CATEGORY` = B.`ID_CATEGORY` AND B.`ID_LANG` = 5
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 2
WHERE (A.`ID_CATEGORY` = 877) AND (B.`ID_SHOP` = 2) LIMIT 10
SELECT *
FROM `NBBL_SHOP` A
WHERE (A.`ID_SHOP` = 2) LIMIT 10
SELECT SU.PHYSICAL_URI, SU.VIRTUAL_URI, SU.DOMAIN, SU.DOMAIN_SSL
              FROM NBBL_SHOP S
              LEFT JOIN NBBL_SHOP_URL SU ON (S.ID_SHOP = SU.ID_SHOP)
              WHERE S.ID_SHOP = 2
              AND S.ACTIVE = 1 AND S.DELETED = 0 AND SU.MAIN = 1 LIMIT 10
SELECT COUNT(DISTINCT L.ID_LANG) FROM `NBBL_LANG` L
				JOIN NBBL_LANG_SHOP LANG_SHOP ON (LANG_SHOP.ID_LANG = L.ID_LANG AND LANG_SHOP.ID_SHOP = 2)
				WHERE L.`ACTIVE` = 1 LIMIT 10
SELECT M.PAGE, ML.URL_REWRITE, ML.ID_LANG
					FROM `NBBL_META` M
					LEFT JOIN `NBBL_META_LANG` ML ON (M.ID_META = ML.ID_META AND ML.ID_SHOP = 2 )
					ORDER BY LENGTH(ML.URL_REWRITE) DESC0
SELECT *
FROM `NBBL_COUNTRY` A
LEFT JOIN `NBBL_COUNTRY_SHOP` `C` ON A.`ID_COUNTRY` = C.`ID_COUNTRY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_COUNTRY` = 26) LIMIT 10
SELECT *
							FROM `NBBL_COUNTRY_LANG`
							WHERE `ID_COUNTRY` = 260
SELECT *
FROM `NBBL_COUNTRY` A
LEFT JOIN `NBBL_COUNTRY_SHOP` `C` ON A.`ID_COUNTRY` = C.`ID_COUNTRY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_COUNTRY` = 10) LIMIT 10
SELECT *
							FROM `NBBL_COUNTRY_LANG`
							WHERE `ID_COUNTRY` = 100
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_LANG` `B` ON A.`ID_CATEGORY` = B.`ID_CATEGORY` AND B.`ID_LANG` = 8
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 23
WHERE (A.`ID_CATEGORY` = 877) AND (B.`ID_SHOP` = 23) LIMIT 10
SELECT *
FROM `NBBL_SHOP` A
WHERE (A.`ID_SHOP` = 23) LIMIT 10
SELECT SU.PHYSICAL_URI, SU.VIRTUAL_URI, SU.DOMAIN, SU.DOMAIN_SSL
              FROM NBBL_SHOP S
              LEFT JOIN NBBL_SHOP_URL SU ON (S.ID_SHOP = SU.ID_SHOP)
              WHERE S.ID_SHOP = 23
              AND S.ACTIVE = 1 AND S.DELETED = 0 AND SU.MAIN = 1 LIMIT 10
SELECT COUNT(DISTINCT L.ID_LANG) FROM `NBBL_LANG` L
				JOIN NBBL_LANG_SHOP LANG_SHOP ON (LANG_SHOP.ID_LANG = L.ID_LANG AND LANG_SHOP.ID_SHOP = 23)
				WHERE L.`ACTIVE` = 1 LIMIT 10
SELECT M.PAGE, ML.URL_REWRITE, ML.ID_LANG
					FROM `NBBL_META` M
					LEFT JOIN `NBBL_META_LANG` ML ON (M.ID_META = ML.ID_META AND ML.ID_SHOP = 23 )
					ORDER BY LENGTH(ML.URL_REWRITE) DESC0
SELECT *
FROM `NBBL_COUNTRY` A
LEFT JOIN `NBBL_COUNTRY_SHOP` `C` ON A.`ID_COUNTRY` = C.`ID_COUNTRY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_COUNTRY` = 15) LIMIT 10
SELECT *
							FROM `NBBL_COUNTRY_LANG`
							WHERE `ID_COUNTRY` = 150
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_LANG` `B` ON A.`ID_CATEGORY` = B.`ID_CATEGORY` AND B.`ID_LANG` = 4
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 3
WHERE (A.`ID_CATEGORY` = 877) AND (B.`ID_SHOP` = 3) LIMIT 10
SELECT *
FROM `NBBL_SHOP` A
WHERE (A.`ID_SHOP` = 3) LIMIT 10
SELECT SU.PHYSICAL_URI, SU.VIRTUAL_URI, SU.DOMAIN, SU.DOMAIN_SSL
              FROM NBBL_SHOP S
              LEFT JOIN NBBL_SHOP_URL SU ON (S.ID_SHOP = SU.ID_SHOP)
              WHERE S.ID_SHOP = 3
              AND S.ACTIVE = 1 AND S.DELETED = 0 AND SU.MAIN = 1 LIMIT 10
SELECT COUNT(DISTINCT L.ID_LANG) FROM `NBBL_LANG` L
				JOIN NBBL_LANG_SHOP LANG_SHOP ON (LANG_SHOP.ID_LANG = L.ID_LANG AND LANG_SHOP.ID_SHOP = 3)
				WHERE L.`ACTIVE` = 1 LIMIT 10
SELECT M.PAGE, ML.URL_REWRITE, ML.ID_LANG
					FROM `NBBL_META` M
					LEFT JOIN `NBBL_META_LANG` ML ON (M.ID_META = ML.ID_META AND ML.ID_SHOP = 3 )
					ORDER BY LENGTH(ML.URL_REWRITE) DESC0
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "PS_FACEBOOK" LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE_SHOP` WHERE `ID_MODULE` = 453 AND `ID_SHOP` = 22 LIMIT 10
SELECT `ID_MODULE` FROM `NBBL_MODULE` WHERE `NAME` = "PS_ACCOUNTS" LIMIT 10
SELECT ID_TRUSTEDSHOPS_CHANNEL
FROM `NBBL_TRUSTEDSHOPS_CHANNEL`
WHERE (ID_CLIENT = '04AAD7FA4DC7__PRESTASHOP') AND (ID_LANG = 1) AND (ID_SHOP = 22) LIMIT 10
SELECT *
FROM `NBBL_TRUSTEDSHOPS_CHANNEL` A
WHERE (A.`ID_TRUSTEDSHOPS_CHANNEL` = 6) LIMIT 10
SELECT `NAME`
							FROM `NBBL_HOOK`
							WHERE `ID_HOOK` = 14 LIMIT 10
SELECT *
FROM `NBBL_FEATURE` A
LEFT JOIN `NBBL_FEATURE_LANG` `B` ON A.`ID_FEATURE` = B.`ID_FEATURE` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_FEATURE_SHOP` `C` ON A.`ID_FEATURE` = C.`ID_FEATURE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_FEATURE` = 6) LIMIT 10
SELECT *
FROM `NBBL_FEATURE_VALUE` A
LEFT JOIN `NBBL_FEATURE_VALUE_LANG` `B` ON A.`ID_FEATURE_VALUE` = B.`ID_FEATURE_VALUE` AND B.`ID_LANG` = 1
WHERE (A.`ID_FEATURE_VALUE` = 1002) LIMIT 10
SELECT *
FROM `NBBL_FEATURE_VALUE` A
LEFT JOIN `NBBL_FEATURE_VALUE_LANG` `B` ON A.`ID_FEATURE_VALUE` = B.`ID_FEATURE_VALUE` AND B.`ID_LANG` = 1
WHERE (A.`ID_FEATURE_VALUE` = 1120) LIMIT 10
SELECT *
FROM `NBBL_FEATURE_VALUE` A
LEFT JOIN `NBBL_FEATURE_VALUE_LANG` `B` ON A.`ID_FEATURE_VALUE` = B.`ID_FEATURE_VALUE` AND B.`ID_LANG` = 1
WHERE (A.`ID_FEATURE_VALUE` = 1252) LIMIT 10
SELECT TYPE, ID_VALUE, FILTER_SHOW_LIMIT, FILTER_TYPE FROM NBBL_LAYERED_CATEGORY
            WHERE ID_CATEGORY = 877
            AND ID_SHOP = 22
            GROUP BY `TYPE`, ID_VALUE ORDER BY POSITION ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT AG.ID_ATTRIBUTE_GROUP, AGL.PUBLIC_NAME AS ATTRIBUTE_GROUP_NAME, IS_COLOR_GROUP, IF(LIAGLV.`URL_NAME` IS NULL OR LIAGLV.`URL_NAME` = "", NULL, LIAGLV.`URL_NAME`) AS URL_NAME, IF(LIAGLV.`META_TITLE` IS NULL OR LIAGLV.`META_TITLE` = "", NULL, LIAGLV.`META_TITLE`) AS META_TITLE, IFNULL(LIAG.INDEXABLE, TRUE) AS INDEXABLE FROM `NBBL_ATTRIBUTE_GROUP` AG  INNER JOIN NBBL_ATTRIBUTE_GROUP_SHOP ATTRIBUTE_GROUP_SHOP
        ON (ATTRIBUTE_GROUP_SHOP.ID_ATTRIBUTE_GROUP = AG.ID_ATTRIBUTE_GROUP AND ATTRIBUTE_GROUP_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL ON (AG.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_ATTRIBUTE_GROUP` LIAG ON (AG.`ID_ATTRIBUTE_GROUP` = LIAG.`ID_ATTRIBUTE_GROUP`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_ATTRIBUTE_GROUP_LANG_VALUE` AS LIAGLV ON (AG.`ID_ATTRIBUTE_GROUP` = LIAGLV.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1) GROUP BY AG.ID_ATTRIBUTE_GROUP ORDER BY AG.`POSITION` ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT V.*, VL.*, IF(LIFVLV.`URL_NAME` IS NULL OR LIFVLV.`URL_NAME` = "", NULL, LIFVLV.`URL_NAME`) AS URL_NAME, IF(LIFVLV.`META_TITLE` IS NULL OR LIFVLV.`META_TITLE` = "", NULL, LIFVLV.`META_TITLE`) AS META_TITLE FROM `NBBL_FEATURE_VALUE` V LEFT JOIN `NBBL_FEATURE_VALUE_LANG` VL ON (V.`ID_FEATURE_VALUE` = VL.`ID_FEATURE_VALUE` AND VL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_VALUE_LANG_VALUE` LIFVLV ON (V.`ID_FEATURE_VALUE` = LIFVLV.`ID_FEATURE_VALUE` AND LIFVLV.`ID_LANG` = 1) WHERE V.`ID_FEATURE` = 6 ORDER BY VL.`VALUE` ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT TYPE, ID_VALUE, FILTER_SHOW_LIMIT, FILTER_TYPE FROM NBBL_LAYERED_CATEGORY WHERE ID_CATEGORY = 877 AND ID_SHOP = 22 GROUP BY `TYPE`, ID_VALUE ORDER BY POSITION ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT V.*, VL.*, IF(LIFVLV.`URL_NAME` IS NULL OR LIFVLV.`URL_NAME` = "", NULL, LIFVLV.`URL_NAME`) AS URL_NAME, IF(LIFVLV.`META_TITLE` IS NULL OR LIFVLV.`META_TITLE` = "", NULL, LIFVLV.`META_TITLE`) AS META_TITLE FROM `NBBL_FEATURE_VALUE` V LEFT JOIN `NBBL_FEATURE_VALUE_LANG` VL ON (V.`ID_FEATURE_VALUE` = VL.`ID_FEATURE_VALUE` AND VL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_VALUE_LANG_VALUE` LIFVLV ON (V.`ID_FEATURE_VALUE` = LIFVLV.`ID_FEATURE_VALUE` AND LIFVLV.`ID_LANG` = 1) WHERE V.`ID_FEATURE` = 9 ORDER BY VL.`VALUE` ASC0
SELECT DISTINCT A.`ID_ATTRIBUTE`, A.`COLOR`, AL.`NAME`, AGL.`ID_ATTRIBUTE_GROUP`, IF(LIALV.`URL_NAME` IS NULL OR LIALV.`URL_NAME` = "", NULL, LIALV.`URL_NAME`) AS URL_NAME, IF(LIALV.`META_TITLE` IS NULL OR LIALV.`META_TITLE` = "", NULL, LIALV.`META_TITLE`) AS META_TITLE FROM `NBBL_ATTRIBUTE_GROUP` AG INNER JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL ON (AG.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1) INNER JOIN `NBBL_ATTRIBUTE` A ON A.`ID_ATTRIBUTE_GROUP` = AG.`ID_ATTRIBUTE_GROUP` INNER JOIN `NBBL_ATTRIBUTE_LANG` AL ON (A.`ID_ATTRIBUTE` = AL.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1) INNER JOIN NBBL_ATTRIBUTE_GROUP_SHOP ATTRIBUTE_GROUP_SHOP
        ON (ATTRIBUTE_GROUP_SHOP.ID_ATTRIBUTE_GROUP = AG.ID_ATTRIBUTE_GROUP AND ATTRIBUTE_GROUP_SHOP.ID_SHOP = 22)  INNER JOIN NBBL_ATTRIBUTE_SHOP ATTRIBUTE_SHOP
        ON (ATTRIBUTE_SHOP.ID_ATTRIBUTE = A.ID_ATTRIBUTE AND ATTRIBUTE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_LAYERED_INDEXABLE_ATTRIBUTE_LANG_VALUE` LIALV ON (A.`ID_ATTRIBUTE` = LIALV.`ID_ATTRIBUTE` AND LIALV.`ID_LANG` = 1) WHERE AG.ID_ATTRIBUTE_GROUP = 1 ORDER BY AGL.`NAME` ASC, A.`POSITION` ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT V.*, VL.*, IF(LIFVLV.`URL_NAME` IS NULL OR LIFVLV.`URL_NAME` = "", NULL, LIFVLV.`URL_NAME`) AS URL_NAME, IF(LIFVLV.`META_TITLE` IS NULL OR LIFVLV.`META_TITLE` = "", NULL, LIFVLV.`META_TITLE`) AS META_TITLE FROM `NBBL_FEATURE_VALUE` V LEFT JOIN `NBBL_FEATURE_VALUE_LANG` VL ON (V.`ID_FEATURE_VALUE` = VL.`ID_FEATURE_VALUE` AND VL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_VALUE_LANG_VALUE` LIFVLV ON (V.`ID_FEATURE_VALUE` = LIFVLV.`ID_FEATURE_VALUE` AND LIFVLV.`ID_LANG` = 1) WHERE V.`ID_FEATURE` = 6 ORDER BY VL.`VALUE` ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT V.*, VL.*, IF(LIFVLV.`URL_NAME` IS NULL OR LIFVLV.`URL_NAME` = "", NULL, LIFVLV.`URL_NAME`) AS URL_NAME, IF(LIFVLV.`META_TITLE` IS NULL OR LIFVLV.`META_TITLE` = "", NULL, LIFVLV.`META_TITLE`) AS META_TITLE FROM `NBBL_FEATURE_VALUE` V LEFT JOIN `NBBL_FEATURE_VALUE_LANG` VL ON (V.`ID_FEATURE_VALUE` = VL.`ID_FEATURE_VALUE` AND VL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_VALUE_LANG_VALUE` LIFVLV ON (V.`ID_FEATURE_VALUE` = LIFVLV.`ID_FEATURE_VALUE` AND LIFVLV.`ID_LANG` = 1) WHERE V.`ID_FEATURE` = 8 ORDER BY VL.`VALUE` ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT V.*, VL.*, IF(LIFVLV.`URL_NAME` IS NULL OR LIFVLV.`URL_NAME` = "", NULL, LIFVLV.`URL_NAME`) AS URL_NAME, IF(LIFVLV.`META_TITLE` IS NULL OR LIFVLV.`META_TITLE` = "", NULL, LIFVLV.`META_TITLE`) AS META_TITLE FROM `NBBL_FEATURE_VALUE` V LEFT JOIN `NBBL_FEATURE_VALUE_LANG` VL ON (V.`ID_FEATURE_VALUE` = VL.`ID_FEATURE_VALUE` AND VL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_VALUE_LANG_VALUE` LIFVLV ON (V.`ID_FEATURE_VALUE` = LIFVLV.`ID_FEATURE_VALUE` AND LIFVLV.`ID_LANG` = 1) WHERE V.`ID_FEATURE` = 3 ORDER BY VL.`VALUE` ASC0
SELECT DISTINCT F.ID_FEATURE, F.*, FL.*, IF(LIFLV.`URL_NAME` IS NULL OR LIFLV.`URL_NAME` = "", NULL, LIFLV.`URL_NAME`) AS URL_NAME, IF(LIFLV.`META_TITLE` IS NULL OR LIFLV.`META_TITLE` = "", NULL, LIFLV.`META_TITLE`) AS META_TITLE, LIF.INDEXABLE FROM `NBBL_FEATURE` F  INNER JOIN NBBL_FEATURE_SHOP FEATURE_SHOP
        ON (FEATURE_SHOP.ID_FEATURE = F.ID_FEATURE AND FEATURE_SHOP.ID_SHOP = 22) LEFT JOIN `NBBL_FEATURE_LANG` FL ON (F.`ID_FEATURE` = FL.`ID_FEATURE` AND FL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE` LIF ON (F.`ID_FEATURE` = LIF.`ID_FEATURE`) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_LANG_VALUE` LIFLV ON (F.`ID_FEATURE` = LIFLV.`ID_FEATURE` AND LIFLV.`ID_LANG` = 1) ORDER BY F.`POSITION` ASC0
SELECT V.*, VL.*, IF(LIFVLV.`URL_NAME` IS NULL OR LIFVLV.`URL_NAME` = "", NULL, LIFVLV.`URL_NAME`) AS URL_NAME, IF(LIFVLV.`META_TITLE` IS NULL OR LIFVLV.`META_TITLE` = "", NULL, LIFVLV.`META_TITLE`) AS META_TITLE FROM `NBBL_FEATURE_VALUE` V LEFT JOIN `NBBL_FEATURE_VALUE_LANG` VL ON (V.`ID_FEATURE_VALUE` = VL.`ID_FEATURE_VALUE` AND VL.`ID_LANG` = 1) LEFT JOIN `NBBL_LAYERED_INDEXABLE_FEATURE_VALUE_LANG_VALUE` LIFVLV ON (V.`ID_FEATURE_VALUE` = LIFVLV.`ID_FEATURE_VALUE` AND LIFVLV.`ID_LANG` = 1) WHERE V.`ID_FEATURE` = 16 ORDER BY VL.`VALUE` ASC0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23586
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23586
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT CL.`LINK_REWRITE`
			FROM `NBBL_CATEGORY_LANG` CL
			WHERE `ID_LANG` = 1
			 AND CL.ID_SHOP = 22 
			AND CL.`ID_CATEGORY` = 877 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23586) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23586 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23586 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 182956
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23586 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 182956
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23586 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23586
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 182956
                AND AGL.`ID_LANG` = 10
SELECT TR.*
				FROM `NBBL_TAX_RULE` TR
				JOIN `NBBL_TAX_RULES_GROUP` TRG ON (TR.`ID_TAX_RULES_GROUP` = TRG.`ID_TAX_RULES_GROUP`)
				WHERE TRG.`ACTIVE` = 1
				AND TR.`ID_COUNTRY` = 26
				AND TR.`ID_TAX_RULES_GROUP` = 0
				AND TR.`ID_STATE` IN (0, 0)
				AND ('0' BETWEEN TR.`ZIPCODE_FROM` AND TR.`ZIPCODE_TO`
					OR (TR.`ZIPCODE_TO` = 0 AND TR.`ZIPCODE_FROM` IN(0, '0')))
				ORDER BY TR.`ZIPCODE_FROM` DESC, TR.`ZIPCODE_TO` DESC, TR.`ID_STATE` DESC, TR.`ID_COUNTRY` DESC0
SELECT *
FROM `NBBL_CATEGORY` A
LEFT JOIN `NBBL_CATEGORY_LANG` `B` ON A.`ID_CATEGORY` = B.`ID_CATEGORY` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_CATEGORY_SHOP` `C` ON A.`ID_CATEGORY` = C.`ID_CATEGORY` AND C.`ID_SHOP` = 22
WHERE (A.`ID_CATEGORY` = 2) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 182956) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23586
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23601
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23601
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23601) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23601 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23601 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183091
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23601 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183091
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23601 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23601
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 183091
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 183091) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23601
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23624
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23624
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23624) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23624 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23624 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183298
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23624 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183298
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23624 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23624
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 183298
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 183298) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23624
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23625
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23625
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23625) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23625 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23625 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183307
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23625 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183307
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23625 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23625
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 183307
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 183307) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23625
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23627
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23627
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23627) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23627 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23627 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183325
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23627 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183325
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23627 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23627
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 183325
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 183325) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23627
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23678
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23678
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23678) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23678 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23678 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183784
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23678 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183784
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23678 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23678
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 183784
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 183784) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23678
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23694
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23694
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23694) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23694 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23694 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183928
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23694 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 183928
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23694 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23694
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 183928
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 183928) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23694
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23711
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23711
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23711) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23711 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23711 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 184081
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23711 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 184081
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23711 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23711
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 184081
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 184081) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23711
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23902
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23902
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23902) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23902 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23902 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 185897
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23902 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 185897
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23902 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23902
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 185897
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 185897) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23902
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23903
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23903
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23903) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23903 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23903 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 185906
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23903 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 185906
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23903 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23903
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 185906
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 185906) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23903
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23913
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23913
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23913) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23913 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23913 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 185996
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23913 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 185996
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23913 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23913
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 185996
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 185996) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23913
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23916
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23916
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23916) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23916 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23916 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 186023
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23916 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 186023
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23916 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23916
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 186023
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 186023) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23916
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23918
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23918
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23918) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23918 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23918 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 186041
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23918 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 186041
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23918 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23918
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 186041
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 186041) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23918
            ORDER BY `POSITION`0
SELECT
                    P.*,
                    PS.*,
                    PL.*,
                    SA.OUT_OF_STOCK,
                    IFNULL(SA.QUANTITY, 0) AS QUANTITY,
                    (DATEDIFF(
                        P.`DATE_ADD`,
                        DATE_SUB(
                            '2023-06-09 00:00:00',
                            INTERVAL 20 DAY
                        )
                    ) > 0) AS NEW
                FROM NBBL_PRODUCT P
                LEFT JOIN NBBL_PRODUCT_LANG PL
                    ON PL.ID_PRODUCT = P.ID_PRODUCT
                    AND PL.ID_SHOP = 22
                    AND PL.ID_LANG = 1
                LEFT JOIN NBBL_STOCK_AVAILABLE SA   ON SA.ID_PRODUCT = P.ID_PRODUCT
			        AND SA.ID_SHOP = 0
			        AND SA.ID_SHOP_GROUP = 1 LEFT JOIN NBBL_PRODUCT_SHOP PS
			        ON PS.ID_PRODUCT = P.ID_PRODUCT
			        AND PS.ID_SHOP = 22
			    WHERE P.ID_PRODUCT = 23927
			    LIMIT 10
SELECT IMAGE_SHOP.`ID_IMAGE`
                    FROM `NBBL_IMAGE` I
                     INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
                    WHERE I.`ID_PRODUCT` = 23927
                    AND IMAGE_SHOP.`COVER` = 1 LIMIT 10
SELECT NAME FROM NBBL_CATEGORY_LANG WHERE ID_SHOP = 22 AND ID_LANG = 1 AND ID_CATEGORY = 877 LIMIT 10
SELECT *
FROM `NBBL_PRODUCT` A
LEFT JOIN `NBBL_PRODUCT_LANG` `B` ON A.`ID_PRODUCT` = B.`ID_PRODUCT` AND B.`ID_LANG` = 1
LEFT JOIN `NBBL_PRODUCT_SHOP` `C` ON A.`ID_PRODUCT` = C.`ID_PRODUCT` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT` = 23927) AND (B.`ID_SHOP` = 22) LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23927 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 0
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23927 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT `ID_ORDER`
            FROM `NBBL_ORDERS`
            WHERE `ID_CART` = 0 AND ID_SHOP IN (22) LIMIT 10
SELECT
            COALESCE(SUM(FIRST_LEVEL_QUANTITY) + SUM(PACK_QUANTITY), 0) AS DEEP_QUANTITY,
            COALESCE(SUM(FIRST_LEVEL_QUANTITY), 0) AS QUANTITY
          FROM (SELECT CP.`QUANTITY` AS FIRST_LEVEL_QUANTITY, 0 AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 186122
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND CP.`ID_PRODUCT` = 23927 UNION SELECT 0 AS FIRST_LEVEL_QUANTITY, CP.`QUANTITY` * P.`QUANTITY` AS PACK_QUANTITY
          FROM `NBBL_CART_PRODUCT` CP JOIN `NBBL_PACK` P ON CP.`ID_PRODUCT` = P.`ID_PRODUCT_PACK` JOIN `NBBL_PRODUCT` PR ON P.`ID_PRODUCT_PACK` = PR.`ID_PRODUCT`
            WHERE CP.`ID_PRODUCT_ATTRIBUTE` = 186122
            AND CP.`ID_CUSTOMIZATION` = 0
            AND CP.`ID_CART` = 0 AND P.`ID_PRODUCT_ITEM` = 23927 AND (PR.`PACK_STOCK_TYPE` IN (1,2) OR (
            PR.`PACK_STOCK_TYPE` = 3
            AND 0 = 1
        ))) AS Q LIMIT 10
SELECT A.`ID_ATTRIBUTE`, A.`ID_ATTRIBUTE_GROUP`, AL.`NAME`, AGL.`NAME` AS `GROUP`, PA.`REFERENCE`, PA.`EAN13`, PA.`ISBN`, PA.`UPC`, PA.`MPN`
            FROM `NBBL_ATTRIBUTE` A
            LEFT JOIN `NBBL_ATTRIBUTE_LANG` AL
                ON (AL.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE` AND AL.`ID_LANG` = 1)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_COMBINATION` PAC
                ON (PAC.`ID_ATTRIBUTE` = A.`ID_ATTRIBUTE`)
            LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE` PA
                ON (PA.`ID_PRODUCT_ATTRIBUTE` = PAC.`ID_PRODUCT_ATTRIBUTE`)
             INNER JOIN NBBL_PRODUCT_ATTRIBUTE_SHOP PRODUCT_ATTRIBUTE_SHOP
        ON (PRODUCT_ATTRIBUTE_SHOP.ID_PRODUCT_ATTRIBUTE = PA.ID_PRODUCT_ATTRIBUTE AND PRODUCT_ATTRIBUTE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_ATTRIBUTE_GROUP_LANG` AGL
                ON (A.`ID_ATTRIBUTE_GROUP` = AGL.`ID_ATTRIBUTE_GROUP` AND AGL.`ID_LANG` = 1)
            WHERE PA.`ID_PRODUCT` = 23927
                AND PAC.`ID_PRODUCT_ATTRIBUTE` = 186122
                AND AGL.`ID_LANG` = 10
SELECT *
FROM `NBBL_PRODUCT_ATTRIBUTE` A
LEFT JOIN `NBBL_PRODUCT_ATTRIBUTE_SHOP` `C` ON A.`ID_PRODUCT_ATTRIBUTE` = C.`ID_PRODUCT_ATTRIBUTE` AND C.`ID_SHOP` = 22
WHERE (A.`ID_PRODUCT_ATTRIBUTE` = 186122) LIMIT 10
SELECT IMAGE_SHOP.`COVER`, I.`ID_IMAGE`, IL.`LEGEND`, I.`POSITION`
            FROM `NBBL_IMAGE` I
             INNER JOIN NBBL_IMAGE_SHOP IMAGE_SHOP
        ON (IMAGE_SHOP.ID_IMAGE = I.ID_IMAGE AND IMAGE_SHOP.ID_SHOP = 22)
            LEFT JOIN `NBBL_IMAGE_LANG` IL ON (I.`ID_IMAGE` = IL.`ID_IMAGE` AND IL.`ID_LANG` = 1)
            WHERE I.`ID_PRODUCT` = 23927
            ORDER BY `POSITION`0

    
        
        
        
    
    
                    

Whoops, looks like something went wrong.

(1/1) ContextErrorException

Warning: Cannot modify header information - headers already sent by (output started at /var/www/html/sites/boboli/webspace/override/classes/db/Db.php:152)

in bblgtm.php line 722
at Bblgtm->hookActionProductSearchAfter()in pagecache.php line 1920
at PageCache::execHook()in Hook.php line 24
at Hook::coreCallHook()in Hook.php line 431
at HookCore::callHookOn()in Hook.php line 944
at HookCore::exec()in CategoryController.php line 391
at CategoryController->getProductSearchVariablesList()in bblgtm.php line 255
at Bblgtm->manageDataLayer()in bblgtm.php line 114
at Bblgtm->hookHeader()in pagecache.php line 1920
at PageCache::execHook()in Hook.php line 24
at Hook::coreCallHook()in Hook.php line 431
at HookCore::callHookOn()in Hook.php line 944
at HookCore::exec()in FrontController.php line 598
at FrontControllerCore->initContent()in CategoryController.php line 76
at CategoryController->initContent()in Controller.php line 306
at ControllerCore->run()in Dispatcher.php line 183
at Dispatcher->dispatch()in index.php line 27