{"scheme":"https"}

US

2a03:2880:f800:b::

cloudflare; loops=1

shopwithabc.com

https

meta-externalagent/1.1 (+https://developers.facebook.com/docs/sharing/webmasters/crawler)

941e40c57b5c8263-IAD

*/*

2a03:2880:f800:b::

web, twa\ecomgeneral\middleware\EcomLanguageMiddleware, twa\htmlhelpers\middleware\TWASEOMiddleware, twa\ecomgeneral\middleware\storeRoutesMiddleware, twa\ecomgeneral\middleware\storeDefaultDataMiddleware, twa\ecomauth\middleware\AuthCheckProfileComplete, twa\cache\middleware\CacheMiddleware

select * from `00_cms_seo_by_route` where `cancelled` = 0 order by CHAR_LENGTH(`route`) DESC

select *, header_message_en AS header_message, label_en AS label  from `ecom_stores` where `web_prefix` = 'lb' and `cancelled` = 0 and `published` = 1 limit 1

select *, header_message_en AS header_message, label_en AS label, group_en AS `group` , contact_us_store_information_en AS contact_us_store_information from `ecom_stores` where `id` = 1 and `cancelled` = 0 limit 1

select * from `ecom_currencies` where `id` in ('1')

select * from `settings_v2` where `cancelled` = 0

insert into `ecom_users_temporary` (`token`, `cart`, `ip`, `updated_at`, `created_at`) values ('t_50eff957df2b9ffd5ef59f5ce1404a70', '"[]"', '2a03:2880:f800:b::', '2025-05-18 20:55:00', '2025-05-18 20:55:00')

select * from `00_cms_cache` where `url` = '/lb/en/products'a67bfe4ff2fa4b3bc8a537dc9071a9c3'category_id=64' and `request_signature` = 0 and `cancelled` = ? order by `id` desc limit 1

select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = 'ecom_products' order by ordinal_position asc

select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = 'ecom_products' order by ordinal_position asc

select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = 'ecom_products' order by ordinal_position asc

select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = 'ecom_products' order by ordinal_position asc

SET SESSION group_concat_max_len = 99999999999

select `id`, GROUP_CONCAT(ecom_products_filters_id SEPARATOR ',') AS col from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 and `ecom_products_filters_id` is not null group by 'all' limit 1

select `id`, `version`, `cms_attributes`, label_en AS label, group_en AS `group` from `ecom_products_filters` where `cancelled` = 0 and `id` in ('21', '12', '38', '22', '39', '40', '41', '16', '33', '42', '44', '45', '34', '46', '47', '51', '53', '54', '55', '56', '57', '26', '58', '59', '31', '60', '61', '25', '62', '63', '64', '24', '66', '32', '14', '69', '50', '48', '52', '70', '30', '77', '80', '79', '76', '75', '78', '28', '90', '23', '116', '97', '260', '99', '100', '101', '102', '103', '104', '105', '106', '95', '94', '81', '398', '110', '111', '112', '107', '113', '108', '109', '29', '92', '118', '119', '37', '120', '121', '122', '123', '124', '125', '126', '128', '129', '130', '131', '93', '132', '96', '133', '134', '136', '137', '138', '27', '139', '320', '84', '140', '142', '143', '144', '145', '146', '261', '88', '262', '149', '417', '150', '151', '152', '153', '154', '155', '306', '156', '419', '157', '158', '159', '269', '270', '271', '272', '114', '115', '160', '161', '162', '164', '165', '166', '167', '163', '168', '171', '268', '180', '181', '182', '183', '184', '185', '186', '189', '192', '193', '72', '74', '73', '198', '199', '200', '201', '177', '87', '178', '273', '267', '266', '265', '170', '173', '172', '214', '215', '216', '217', '219', '220', '221', '225', '226', '229', '323', '297', '352', '147', '230', '231', '232', '233', '234', '235', '236', '237', '238', '259', '207', '241', '242', '244', '245', '246', '247', '248', '249', '250', '251', '252', '253', '254', '187', '255', '256', '257', '258', '263', '274', '205', '98', '208', '275', '278', '281', '282', '288', '19', '291', '292', '293', '294', '289', '295', '296', '302', '303', '82', '83', '301', '304', '307', '308', '309', '310', '312', '315', '317', '318', '319', '348', '361', '362', '363', '366', '368', '371', '372', '373', '300', '344', '375', '376', '388', '391', '392', '393', '394', '395', '396', '383', '397', '305', '400', '401', '402', '403', '404', '405', '316', '421', '430', '431', '432', '433', '434', '435', '436', '443', '456', '414', '483', '484', '493', '169', '494', '495', '179', '491', '497', '498', '499', '222', '206', '500', '501', '502', '503', '505', '290', '506', '507', '508', '509', '510', '511', '512', '513', '514', '174', '515', '516', '517', '521', '522', '523', '518', '524', '535', '527', '526', '528', '529', '408', '532', '530', '533', '534', '540', '541', '542', '538', '545', '209', '210', '211', '213', '228', '537', '135', '547', '548', '549', '551', '378', '552', '553', '554', '555', '556', '557', '558', '313', '559', '560', '561', '562', '563', '564', '212', '565', '566', '567', '568', '569', '570', '571', '18', '572', '15', '20', '13', '573', '574', '539', '117', '577') and (`cms_attributes` is null or `cms_attributes` NOT LIKE '%"frontend_menus_filter":true%') order by `orders` asc

select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/lb/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0

select * from `ecom_products_brands` where `id` in (286, 288, 289, 291, 292, 294, 297, 140, 148, 159, 143, 165, 112, 156, 96, 52, 6, 304, 53, 92, 85, 72, 81, 50, 51, 77, 80, 47, 25, 97, 46, 34, 48, 82, 38, 43, 40, 93, 307, 16, 306, 1, 3, 5, 15, 20, 30, 308, 39, 309, 354, 68, 70, 313, 311, 312, 299, 295, 316, 317, NULL, 216, 267, 285, 293, 296, 319, 152, 150, 120, 321, 322, 323, 325, 326, 327, 328, 329, 330, 331, 332, 333, 334, 335, 336, 337, 338, 339, 340, 341, 342, 343, 344, 345, 346, 347, 348, 349, 350, 351, 352, 107, 318, 103, 110, 109, 115, 225, 264, 270, 117, 119, 121, 124, 154, 145, 130, 137, 247, 186, 7, 55, 19, 11, 90, 387, 59, 63, 64, 18, 23, 8, 31, 389, 69, 36, 13, 89, 391, 71, 56)

select min(`price_ttc`) as aggregate from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0

select max(`price_ttc`) as aggregate from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0

select `ecom_products_categories_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 group by COALESCE(family_group_id,id) order by CASE WHEN stock_quantity > 0 THEN 0 ELSE 1 END, `id` desc

select `ecom_products_brands_id` from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 group by COALESCE(family_group_id,id) order by CASE WHEN stock_quantity > 0 THEN 0 ELSE 1 END, `id` desc

select count(*) as aggregate from (select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/lb/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 group by COALESCE(family_group_id,id)) as `aggregate_table`

select `id`, `ecom_products_bulk_pricing_id`, `price_ttc`, `keywords`, `digital_product`, `ecom_products_giftcards_id`, `ecom_vendors_id`, `ecom_products_brands_id`, `ecom_subcategories_id`, `00_cms_files_image`, `hscode`, `barcode`, `ecom_products_categories_id`, `family_group_id`, (price_ttc - price_ttc * (COALESCE(discount,0) + 0) / 100) AS price, CONCAT("/lb/en/product/",slug) AS link from `ecom_products` where `cancelled` = 0 and `display` = 1 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `no_listing` = 0 group by COALESCE(family_group_id,id) order by CASE WHEN stock_quantity > 0 THEN 0 ELSE 1 END, `id` desc limit 48 offset 0

select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = 'ecom_products' order by ordinal_position asc

select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = 'ecom_products' order by ordinal_position asc

select `id`, `ecom_products_bulk_pricing_id`, `weight`, `width`, `length`, `hscode`, `barcode`, `extension_image`, `sku`, `price_ttc`, `price_shelf`, `version`, `stock_quantity`, `family_group_id`, `keywords`, `gallery`, `cms_attributes`, `ecom_products_tags_id`, `ecom_stores_id`, `ecom_subcategories_id`, `slug`, `digital_product`, `ecom_products_giftcards_id`, `preorder_available`, `ecom_vendors_id`, `ecom_products_brands_id`, `00_cms_files_image`, `created_at`, CONCAT("/lb/en/product/",slug) AS link, COALESCE(discount,0) AS discount, (price_ttc - price_ttc * (LEAST(COALESCE(discount,0) + 0,100) / 100)) AS price, LEAST(COALESCE(discount,0) + 0,100) AS discount, label_en AS label, small_description_en AS small_description, gallery from `ecom_products` where `display` = 1 and `cancelled` = 0 and `price_ttc` > 0 and `ecom_stores_id` = 1 and `id` in (27117, 27111, 27096, 27094, 27079, 27069, 27059, 27044, 27029, 27019, 27004, 26994, 26984, 26959, 26944, 26924, 26918, 26911, 26904, 26890, 26885, 26881, 26877, 26873, 26869, 26865, 26857, 26846, 26806, 26784, 26762, 26755, 26748, 26743, 26731, 26725, 26702, 26698, 26691, 26677, 26670, 26657, 26643, 26633, 26609, 26586, 26557, 26534)

select * from `00_cms_utilities_frontend_menus` where `ecom_stores_id` LIKE '%"1"%' order by `orders` asc limit 1

select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc

select column_name as `name`, data_type as `type_name`, column_type as `type`, collation_name as `collation`, is_nullable as `nullable`, column_default as `default`, column_comment as `comment`, generation_expression as `expression`, extra as `extra` from information_schema.columns where table_schema = 'shopwithabccom_67f68d6bb1758_db_live' and table_name = '00_cms_utilities_frontend_menus_links' order by ordinal_position asc

select * from `00_cms_utilities_frontend_menus` where `label` = 'left top menu' and `ecom_stores_id` LIKE '%"1"%' and `cancelled` = 0 limit 1

select *, label_en AS label, link_en AS link, CONCAT('https://abc.heyacdn.com/abc.com.lb/public/data/front_end_menus/', id , '.', extension_image,'34v=' , version) AS image from `00_cms_utilities_frontend_menus_links` where `00_cms_utilities_frontend_menus_id` = 0 and `cancelled` = ?

select `id`, `extension_image`, `sku`, `price_ttc`, `price_shelf`, `version`, `stock_quantity`, `family_group_id`, `cms_attributes`, `ecom_products_tags_id`, `ecom_stores_id`, `ecom_subcategories_id`, `slug`, `digital_product`, `ecom_products_giftcards_id`, `keywords`, `preorder_available`, `ecom_vendors_id`, `ecom_products_brands_id`, `family_group_id`, COALESCE(discount,0) as discount, CONCAT("/lb/en/product/",slug) AS link, (price_ttc - price_ttc * (LEAST(COALESCE(discount,0) + 0,100) / 100)) AS price, LEAST(COALESCE(discount,0) + 0,100) AS discount, label_en AS label, small_description_en AS small_description, gallery from `ecom_products` where `price_ttc` > 0 and `display` = 1 and `cancelled` = 0 and `family_group_id` in ('HMB10113', 'HMB10112', 'HMB10121', 'HMB10109', 'ICE25MBS09', 'ICE25MBS06', 'ICE25MBS05', 'ICE25MBS04', 'ICE25MBS03', 'ICE25MBS01', 'ICE25MBM14', 'ICE25MBM13', 'ICE25MBM07', 'ICE25MBM03', 'ICE25MBM02', 'ICE25MBM01', '39E618', '39E617', '39E608', '31E910', '19E916', '19E624', '19E061RU', '11E923', '11E907', '11E626', '11E423', 'XXYZ', 'MW0MW39256', 'MW0MW39249', 'MW0MW39235', 'MW0MW39197', 'MW0MW39194', 'MW0MW39188', 'MW0MW39168', 'MW0MW39149', 'MW0MW38898', 'MW0MW38896', 'MW0MW38864', 'MW0MW38823', 'MW0MW38815', 'MW0MW38812', 'MW0MW38801', 'MW0MW38746', 'MW0MW38644', 'MW0MW38637', 'MW0MW38632', 'MW0MW38630') and `ecom_stores_id` = 1 order by `family_group_id` asc, `orders` asc

select * from `ecom_users_reviews` where `cancelled` = 0 and `approved` = 1

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27117 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'HMB10113' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('7', '723', '1', '723', '480', '714', '356', '714', '26', '714', '7', '714')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27111 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'HMB10112' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('26', '724', '7', '724', '1', '724', '480', '723', '356', '723', '26', '723')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27149 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'HMB10121' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('26', '719', '7', '719', '1', '719', '480', '716', '356', '716', '26', '716')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27146 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'HMB10109' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('480', '719', '356', '719', '26', '716', '7', '716', '1', '716')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27079 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'ICE25MBS09' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('1', '3', '7', '3', '26', '3', '356', '3', '480', '3', '1', '40', '7', '40', '26', '40', '356', '40', '480', '40')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27069 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'ICE25MBS06' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('1', '3', '7', '3', '26', '3', '356', '3', '480', '3', '1', '364', '7', '364', '26', '364', '356', '364', '480', '364')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27059 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'ICE25MBS05' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('1', '3', '7', '3', '26', '3', '356', '3', '480', '3', '1', '364', '7', '364', '26', '364', '356', '364', '480', '364')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27044 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'ICE25MBS04' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('1', '3', '7', '3', '26', '3', '356', '3', '480', '3', '1', '33', '7', '33', '26', '33', '356', '33', '480', '33', '1', '364', '7', '364', '26', '364', '356', '364', '480', '364')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27029 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'ICE25MBS03' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('1', '712', '7', '712', '26', '712', '356', '712', '480', '712', '1', '3', '7', '3', '26', '3', '356', '3', '480', '3', '1', '713', '7', '713', '26', '713', '356', '713', '480', '713')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27019 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'ICE25MBS01' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('1', '3', '7', '3', '26', '3', '356', '3', '480', '3', '1', '40', '7', '40', '26', '40', '356', '40', '480', '40')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 27004 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'ICE25MBM14' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('1', '712', '7', '712', '26', '712', '356', '712', '480', '712', '1', '3', '7', '3', '26', '3', '356', '3', '480', '3', '1', '33', '7', '33', '26', '33', '356', '33', '480', '33')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 26994 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'ICE25MBM13' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('1', '3', '7', '3', '26', '3', '356', '3', '480', '3', '1', '492', '7', '492', '26', '492', '356', '492', '480', '492')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 26984 and `cancelled` = 0 limit 1

select `id`, `stock_quantity`, `variations` from `ecom_products` where `family_group_id` = 'ICE25MBM07' and `no_listing` = 0 and `ecom_stores_id` = 1 and `price_ttc` > 0 and `cancelled` = 0

select * from `ecom_products_variations` where `id` in ('1', '3', '7', '3', '26', '3', '356', '3', '480', '3', '1', '76', '7', '76', '26', '76', '356', '76', '480', '76')

select * from `ecom_products_variation_types` where `id` in (10, 11) order by `orders` asc

select count(*) as aggregate from `00_cms_files` where `cancelled` = 0

select * from `ecom_products` where `id` = 26959 and `cancelled` = 0 limit 1