+91 8606900747
LOGIN TO VIEWCLUB CARD POINTS
products
product_list_banner_first
product_list_banner_second
product_list_banner_third
active_filter
filters
category_name
banner
by
paramvalue
p_count
obLevel
__env
app
errors
branches
manufature
menucategories
menucategoriescount
cartcount
wishlistcount
languages
currency
recent_views
locale
bottomfeatures
activeoffers
footercontent
popup_banner
website_title
website_description
greencardpoint
_update_greencard
url
active_filter_array
filtr_collection
__currentLoopData
loop
filter
value
current_filters
filter_values
checked
spec_filter_coll
minimum
maximum
select * from `sessions` where `id` = 'RRjyjgTxXha596vwtevKuFrB0xF15ek7rBymtmsM' limit 1
SELECT *
LIMIT
ORDER BY
select count(*) as aggregate from `languages` where (`status` = '1' and `code` = 'en')
select * from `languages` where (`status` = '1' and `code` = 'en') limit 1
select * from `languages` where `status` = '1'
select * from `currency_languages` inner join `currencies` on `currency_languages`.`currency_id` = `currencies`.`id` where (`language_id` = '1' and `value` = '1') limit 1
select * from `languages` where (`code` = 'en' and `status` = '1') limit 1
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`categories`.`status` = '1' and `parent_id` = '0') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '169') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '170') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '172') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '199') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '200') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '201') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '206') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '207') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '188') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '1') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '5') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '6') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '7') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '2') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '9') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '10') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '11') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '12') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '13') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '14') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '15') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '16') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '17') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '18') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '19') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '20') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '21') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '22') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '23') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '24') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '25') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '26') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '27') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '28') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '37') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '38') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '39') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '40') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '41') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '42') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '43') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '44') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '45') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '46') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '29') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '30') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '31') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '32') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '72') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '33') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '73') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '34') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '35') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '36') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '47') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '48') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '49') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '50') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '51') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '185') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '52') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '53') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '54') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '55') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '56') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '57') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '58') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '59') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '60') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '181') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '61') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '62') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '63') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '64') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '66') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '67') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '68') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '69') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '70') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '189') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '71') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '75') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '76') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '8') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '3') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '77') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '78') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '79') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '80') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '81') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '82') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '83') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '84') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '85') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '184') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '86') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '87') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '88') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '89') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '90') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '91') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '92') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '94') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '95') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '192') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '96') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '191') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '97') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '98') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '99') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '100') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '101') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '102') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '103') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '104') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '105') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '106') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '107') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '117') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '118') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '119') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '120') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '121') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '122') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '123') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '124') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '126') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '127') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '128') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '129') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '130') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '108') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '109') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '110') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '111') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '112') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '113') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '114') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '115') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '131') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '132') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '133') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '134') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '4') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '135') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '136') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '137') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '138') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '139') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '142') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '140') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '141') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '144') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '174') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '182') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '145') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '146') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '147') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '148') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '149') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '150') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '151') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '152') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '153') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '154') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '155') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '156') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '157') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '158') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '186') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '187') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '161') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '203') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '204') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '178') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '175') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '176') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '190') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '197') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '177') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '179') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '183') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '180') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '162') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '163') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '164') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '166') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `categories` inner join `category_languages` on `categories`.`id` = `category_languages`.`category_id` where (`status` = '1' and `parent_id` = '202') and (`category_languages`.`language_id` = '1') order by `categories`.`order_number` asc
select * from `offers` inner join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` where (`start_date` <= '2025-07-06 13:14:11' or `start_date` is null) and (`end_date` >= '2025-07-06 13:14:11' or `end_date` is null) and (`status` = '1') and `offer_languages`.`language_id` = '1' order by `offers`.`created_at` desc limit 1
select * from `page_contents` where (`page` = 'Footer' and `language_code` = 'en')
select count(*) as aggregate from `carts` where `customer_id` = '0'
select count(*) as aggregate from `wishlists` where `customer_id` = '0'
select * from `banners` inner join `banner_languages` on `banners`.`id` = `banner_languages`.`banner_id` inner join `languages` on `languages`.`id` = `banner_languages`.`language_id` where (`start_time` <= '2025-07-06 13:14:11' or `start_time` is null) and (`end_time` >= '2025-07-06 13:14:11' or `end_time` is null) and (`is_active` = '1' and `banner_type_id` = '9') and `languages`.`code` = 'en' order by `order_number` asc
select * from `website_banners` inner join `website_banner_languages` on `website_banners`.`id` = `website_banner_languages`.`banner_id` inner join `languages` on `languages`.`id` = `website_banner_languages`.`language_id` where exists (select * from `website_banner_types` where `website_banners`.`banner_type_id` = `website_banner_types`.`id` and `status` = '1') and (`start_time` <= '2025-07-06 13:14:11' or `start_time` is null) and (`end_time` >= '2025-07-06 13:14:11' or `end_time` is null) and (`is_active` = '1') and `languages`.`code` = 'en' and `banner_type_id` in ('22')
select * from `branches` where `id` not in ('7', '8', '9')
select `manufacturers`.`id`, `manufacturers`.`status`, `manufacturers`.`image`, `manufacturers`.`slug`, `manufacturer_languages`.`name` from `manufacturers` inner join `manufacturer_languages` on `manufacturer_languages`.`manufacturer_id` = `manufacturers`.`id` where (`status` = '1' and `manufacturer_languages`.`language_id` = '1') and `is_shown` = '1' order by `name` asc
select * from `settings` where `key` = 'seo_title' limit 1
select * from `settings` where `key` = 'seo_description' limit 1
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YToyOntzOjY6Il90b2tlbiI7czo0MDoick5mSlFuWmJmcmM2RGZac2J6N0MwRGRLdEhteFlwRmVCRkVXWEdVUSI7czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319fQ==', '1751787851', '', '216.73.216.204', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'RRjyjgTxXha596vwtevKuFrB0xF15ek7rBymtmsM')
select * from `categories` where `slug` = 'home-care'
select * from `category_languages` where `category_languages`.`category_id` in ('4')
select * from `categories` where `slug` = 'home-care' limit 1
select count(*) as aggregate from `products` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `stores` on `product_stores`.`store_id` = `stores`.`id` inner join `currencies` on `currencies`.`id` = 1 left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` left join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and (`product_stores`.`store_id` = (select store_id from product_stores where product_stores.product_id=products.id order by current_price limit 1) and `product_stores`.`status` = '1') and `is_show_in_list` = '1' and `products`.`deleted_at` is null group by `products`.`id`
select count(*) as aggregate from `categories` where (`slug` = 'home-care' and `status` = '1')
select * from `categories` where (`slug` = 'home-care' and `status` = '1') limit 1
select count(*) as aggregate from `categories` where (`status` = '1' and `parent_id` = '4')
select `categories`.`id`, `categories`.`parent_id` from `categories` where (`status` = '1' and `parent_id` = '4')
select * from `categories` where (`status` = '1') and `categories`.`parent_id` in ('135', '145', '149', '156', '162', '175', '203')
select * from `categories` where `categories`.`parent_id` = '136' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '137' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '138' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '139' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '140' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '141' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '142' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '144' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '174' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '182' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '146' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '147' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '148' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '150' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '151' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '152' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '153' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '154' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '155' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '157' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '158' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '161' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '186' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '187' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '163' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '164' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '166' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '202' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '176' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '177' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '179' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '180' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '183' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '190' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '197' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '178' and `categories`.`parent_id` is not null and (`status` = '1')
select * from `categories` where `categories`.`parent_id` = '204' and `categories`.`parent_id` is not null and (`status` = '1')
select count(*) as aggregate from `products` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `stores` on `product_stores`.`store_id` = `stores`.`id` inner join `currencies` on `currencies`.`id` = 1 left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` left join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and (`product_stores`.`store_id` = (select store_id from product_stores where product_stores.product_id=products.id order by current_price limit 1) and `product_stores`.`status` = '1') and `is_show_in_list` = '1' and exists (select * from `product_categories` where `products`.`id` = `product_categories`.`product_id` and (`category_id` = '4' or `category_id` in ('135', '136', '137', '138', '139', '140', '141', '142', '144', '174', '182', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '186', '187', '162', '163', '164', '166', '202', '175', '176', '177', '179', '180', '183', '190', '197', '203', '178', '204'))) and `products`.`deleted_at` is null group by `products`.`id`
select count(*) as aggregate from `products` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `stores` on `product_stores`.`store_id` = `stores`.`id` inner join `currencies` on `currencies`.`id` = 1 left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` left join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and (`product_stores`.`store_id` = (select store_id from product_stores where product_stores.product_id=products.id order by current_price limit 1) and `product_stores`.`status` = '1') and `is_show_in_list` = '1' and exists (select * from `product_categories` where `products`.`id` = `product_categories`.`product_id` and (`category_id` = '4' or `category_id` in ('135', '136', '137', '138', '139', '140', '141', '142', '144', '174', '182', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '186', '187', '162', '163', '164', '166', '202', '175', '176', '177', '179', '180', '183', '190', '197', '203', '178', '204'))) and `products`.`status` = '1' and `products`.`deleted_at` is null group by `products`.`id`
select count(*) as aggregate from `products` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `stores` on `product_stores`.`store_id` = `stores`.`id` inner join `currencies` on `currencies`.`id` = 1 left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` left join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and (`product_stores`.`store_id` = (select store_id from product_stores where product_stores.product_id=products.id order by current_price limit 1) and `product_stores`.`status` = '1') and `is_show_in_list` = '1' and exists (select * from `product_categories` where `products`.`id` = `product_categories`.`product_id` and (`category_id` = '4' or `category_id` in ('135', '136', '137', '138', '139', '140', '141', '142', '144', '174', '182', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '186', '187', '162', '163', '164', '166', '202', '175', '176', '177', '179', '180', '183', '190', '197', '203', '178', '204'))) and `products`.`status` = '1' and `products`.`deleted_at` is null group by `products`.`id` order by `products`.`order_number` asc
select `products`.`id`, `products`.`slug`, `products`.`status`, `products`.`product_offer`, stores.slug as storeslug, `products`.`purchase_reward`, `products`.`reward_point`, `products`.`code`, `product_languages`.`name`, `product_languages`.`app_description`, `products`.`manufacturer_id`, `product_stores`.`store_id`, `currencies`.`value`, `currency_languages`.`symbol_left`, `currency_languages`.`symbol_right`, ROUND(product_stores.default_price * currencies.value,2) as oldprice, ROUND(IFNULL(getprice(products.id,'2025-07-06 13:14:11',0,1),(product_stores.current_price * currencies.value)),2) as price, IFNULL(getdiscount(products.id,'2025-07-06 13:14:11',0,1),"0|nil") as discount, (select IFNULL(ROUND(avg(rating),0),0) from product_reviews where product_id=products.id and status=1) as rating, IFNULL((select image from product_images where product_id=CASE WHEN products.is_show_in_list=1 THEN products.id ELSE products.parent_id END and is_default=1),"") as image, (select IF(count(product_id)>0,1,0) from wishlists w join wishlist_items wi on w.id=wi.wishlist_id where wi.product_id=products.id and wi.store_id=product_stores.store_id and w.customer_id=0) as wishlist, (select IF(count(product_id)>0,1,0) from carts c join cart_items ci on c.id=ci.cart_id where ci.product_id=products.id and ci.store_id=product_stores.store_id and c.customer_id=0) as cart, (select IF(count(product_id)>0,quantity,0) from carts c join cart_items ci on c.id=ci.cart_id where ci.product_id=products.id and ci.store_id=product_stores.store_id and c.customer_id=0) as quantity, stores.slug as store, manufacturer_languages.name as manufacturer, product_stores.stock as stock from `products` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `stores` on `product_stores`.`store_id` = `stores`.`id` inner join `currencies` on `currencies`.`id` = 1 left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` left join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and (`product_stores`.`store_id` = (select store_id from product_stores where product_stores.product_id=products.id order by current_price limit 1) and `product_stores`.`status` = '1') and `is_show_in_list` = '1' and exists (select * from `product_categories` where `products`.`id` = `product_categories`.`product_id` and (`category_id` = '4' or `category_id` in ('135', '136', '137', '138', '139', '140', '141', '142', '144', '174', '182', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '186', '187', '162', '163', '164', '166', '202', '175', '176', '177', '179', '180', '183', '190', '197', '203', '178', '204'))) and `products`.`status` = '1' and `products`.`deleted_at` is null group by `products`.`id` order by `products`.`order_number` asc limit 40 offset 800
select count(*) as aggregate from `products` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` inner join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currencies` on `currencies`.`id` = 1 inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and `manufacturer_languages`.`language_id` = '1' and `product_stores`.`status` = '1' and `products`.`deleted_at` is null
select count(*) as aggregate from `products` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` inner join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currencies` on `currencies`.`id` = 1 inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and `manufacturer_languages`.`language_id` = '1' and `product_stores`.`status` = '1' and exists (select * from `product_categories` where `products`.`id` = `product_categories`.`product_id` and (`category_id` = '4' or `category_id` in ('135', '136', '137', '138', '139', '140', '141', '142', '144', '174', '182', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '186', '187', '162', '163', '164', '166', '202', '175', '176', '177', '179', '180', '183', '190', '197', '203', '178', '204'))) and `products`.`deleted_at` is null
select min(IFNULL(getprice(products.id,'2025-07-06 13:14:11',0,1),(product_stores.current_price * currencies.value))) as aggregate from `products` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` inner join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currencies` on `currencies`.`id` = 1 inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and `manufacturer_languages`.`language_id` = '1' and `product_stores`.`status` = '1' and exists (select * from `product_categories` where `products`.`id` = `product_categories`.`product_id` and (`category_id` = '4' or `category_id` in ('135', '136', '137', '138', '139', '140', '141', '142', '144', '174', '182', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '186', '187', '162', '163', '164', '166', '202', '175', '176', '177', '179', '180', '183', '190', '197', '203', '178', '204'))) and `products`.`deleted_at` is null
select max(IFNULL(getprice(products.id,'2025-07-06 13:14:11',0,1),(product_stores.current_price * currencies.value))) as aggregate from `products` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` inner join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currencies` on `currencies`.`id` = 1 inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and `manufacturer_languages`.`language_id` = '1' and `product_stores`.`status` = '1' and exists (select * from `product_categories` where `products`.`id` = `product_categories`.`product_id` and (`category_id` = '4' or `category_id` in ('135', '136', '137', '138', '139', '140', '141', '142', '144', '174', '182', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '186', '187', '162', '163', '164', '166', '202', '175', '176', '177', '179', '180', '183', '190', '197', '203', '178', '204'))) and `products`.`deleted_at` is null
select `products`.`id` from `products` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` inner join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currencies` on `currencies`.`id` = 1 inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and `manufacturer_languages`.`language_id` = '1' and `product_stores`.`status` = '1' and exists (select * from `product_categories` where `products`.`id` = `product_categories`.`product_id` and (`category_id` = '4' or `category_id` in ('135', '136', '137', '138', '139', '140', '141', '142', '144', '174', '182', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '186', '187', '162', '163', '164', '166', '202', '175', '176', '177', '179', '180', '183', '190', '197', '203', '178', '204'))) and `products`.`deleted_at` is null
select distinct category_languages.category_id as filter_value_id,category_languages.name,categories.parent_id from `products` inner join `product_stores` on `products`.`id` = `product_stores`.`product_id` inner join `product_languages` on `products`.`id` = `product_languages`.`product_id` left join `manufacturers` on `products`.`manufacturer_id` = `manufacturers`.`id` inner join `manufacturer_languages` on `manufacturers`.`id` = `manufacturer_languages`.`manufacturer_id` inner join `currencies` on `currencies`.`id` = 1 inner join `currency_languages` on `currencies`.`id` = `currency_languages`.`currency_id` and `currency_languages`.`language_id` = 1 inner join `product_categories` on `product_categories`.`product_id` = `products`.`id` inner join `category_languages` on `category_languages`.`category_id` = `product_categories`.`category_id` inner join `categories` on `category_languages`.`category_id` = `categories`.`id` where `product_languages`.`language_id` = '1' and `products`.`status` = '1' and `manufacturer_languages`.`language_id` = '1' and `product_stores`.`status` = '1' and exists (select * from `product_categories` where `products`.`id` = `product_categories`.`product_id` and (`category_id` = '4' or `category_id` in ('135', '136', '137', '138', '139', '140', '141', '142', '144', '174', '182', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '156', '157', '158', '161', '186', '187', '162', '163', '164', '166', '202', '175', '176', '177', '179', '180', '183', '190', '197', '203', '178', '204'))) and `category_languages`.`language_id` = '1' and `products`.`deleted_at` is null
select * from `category_languages` where (`category_id` = '145' and `language_id` = '1') limit 1
select * from `category_languages` where (`category_id` = '135' and `language_id` = '1') limit 1
select * from `category_languages` where (`category_id` = '156' and `language_id` = '1') limit 1
select * from `category_languages` where (`category_id` = '172' and `language_id` = '1') limit 1
select * from `category_languages` where (`category_id` = '162' and `language_id` = '1') limit 1
select * from `category_languages` where (`category_id` = '175' and `language_id` = '1') limit 1
select * from `category_languages` where (`category_id` = '149' and `language_id` = '1') limit 1
select * from `category_languages` where (`category_id` = '4' and `language_id` = '1') limit 1
select * from `category_languages` where (`category_id` = '203' and `language_id` = '1') limit 1
select count(*) as aggregate from `offers` inner join `offer_languages` on `offers`.`id` = `offer_languages`.`offer_id` where (`start_date` <= '2025-07-06 13:14:12' or `start_date` is null) and (`end_date` >= '2025-07-06 13:14:12' or `end_date` is null) and (`status` = '1') and `offer_languages`.`language_id` = '1' and ((exists (select * from `offer_categories` where `offers`.`id` = `offer_categories`.`offer_id` and `category_id` in ('146', '148', '174', '186', '147', '137', '161', '158', '201', '163', '164', '166', '179', '183', '182', '177', '144', '142', '155', '187', '139', '150', '140', '151', '136', '141', '154', '188', '190', '197', '202', '152', '138', '149', '180', '169', '200', '153', '157', '176', '178')) or exists (select * from `offer_products` where `offers`.`id` = `offer_products`.`offer_id` and `product_id` in ('5967', '5968', '5982', '5983', '5999', '6021', '6023', '6038', '6039', '6047', '6054', '6068', '6699', '6701', '6704', '6705', '6707', '6708', '6709', '6726', '6727', '6728', '6729', '6730', '6731', '6762', '6763', '6804', '6805', '6806', '6807', '6808', '6811', '6812', '6813', '6814', '6815', '6819', '6822', '6823', '6826', '6831', '6841', '6842', '6843', '6844', '6847', '6848', '6932', '6933', '6934', '6935', '6936', '6937', '6939', '6940', '6941', '6942', '6943', '6944', '6945', '6946', '6947', '7195', '7196', '7197', '7198', '7199', '7200', '7201', '7202', '7203', '7204', '7205', '7206', '7207', '7208', '7209', '7210', '7211', '7212', '7213', '7214', '7215', '8166', '8189', '8241', '8242', '8243', '8244', '8245', '8246', '8251', '8252', '8464', '8633', '8650', '8666', '8667', '8668', '8669', '8670', '8671', '8672', '8673', '8674', '8675', '8676', '8677', '8678', '8679', '8680', '8681', '8682', '8699', '8730', '8731', '8766', '8771', '8772', '8773', '8843', '8876', '8891', '8892', '8893', '8894', '8895', '8933', '8934', '8935', '8969', '8983', '8984', '8987', '8988', '8990', '8991', '8992', '8993', '8994', '8995', '8996', '8997', '8998', '9013', '9015', '9022', '9024', '9025', '9026', '9027', '9039', '9076', '9077', '9078', '9079', '9080', '9081', '9083', '9084', '9085', '9086', '9087', '9088', '9089', '9090', '9091', '9098', '9099', '9100', '9101', '9102', '9103', '9120', '9122', '9124', '9125', '9126', '9206', '9207', '9208', '9209', '9210', '9211', '9212', '9213', '9214', '9215', '9230', '9364', '9365', '9369', '9370', '9371', '9376', '9377', '9378', '9393', '9394', '9395', '9396', '9397', '9398', '9399', '9400', '9406', '9408', '9409', '9410', '9411', '9412', '9430', '9432', '9433', '9434', '9436', '9437', '9438', '9439', '9440', '9441', '9442', '9443', '9444', '9445', '9446', '9447', '5952', '6773', '5953', '5954', '5955', '5956', '5957', '5958', '6056', '6088', '6165', '6167', '6199', '6205', '6309', '6648', '8739', '8853', '8985', '9028', '9029', '9030', '9117', '9287', '9288', '9289', '5959', '5960', '6089', '6764', '6765', '6766', '6767', '6778', '6779', '6803', '6895', '6896', '8097', '8098', '8099', '8100', '8101', '8102', '8103', '8931', '9048', '9049', '9050', '9129', '5962', '6090', '6077', '8290', '5966', '6742', '6743', '6781', '9133', '6672', '6161', '6162', '6174', '6175', '6181', '6218', '6219', '6220', '6221', '6222', '6223', '6224', '6225', '6226', '6227', '6228', '6230', '6231', '6232', '6233', '6234', '6235', '6236', '6237', '6238', '6239', '6284', '6290', '6293', '6294', '6301', '6304', '6643', '6652', '6719', '6720', '6724', '8764', '8765', '8889', '8890', '8930', '9008', '9018', '9019', '9034', '9035', '9036', '9037', '9118', '9119', '6163', '6017', '6018', '6044', '6059', '6164', '6176', '6177', '6178', '6179', '6180', '6182', '6262', '6263', '6264', '6265', '6266', '6267', '6268', '6269', '6278', '6280', '6283', '6287', '6292', '6302', '6305', '6306', '6721', '6722', '6723', '8701', '8851', '6058', '6099', '6169', '6260', '6658', '6659', '6673', '6171', '6213', '9040', '9041', '9042', '9043', '9044', '9045', '9046', '6166', '6649', '6650', '8703', '8849', '8850', '8852', '8861', '9032', '9033', '9127', '9131', '9366', '9367', '9368', '9380', '6091', '6092', '6093', '6094', '6095', '6096', '6097', '6098', '6172', '6173', '6100', '6193', '6194', '6195', '6196', '6197', '6198', '6208', '6209', '6073', '6074', '6242', '6243', '6244', '6245', '6246', '6247', '6248', '6249', '6250', '6251', '6252', '6253', '6254', '6255', '6307', '8702', '8936', '8989', '9121', '9372', '9373', '9374', '9375', '9379', '6256', '6257', '6184', '6185', '6186', '6187', '6188', '6189', '6191', '6192', '8035', '8036', '8919', '8920', '6210', '6211', '6212', '8932', '6087', '6240', '6241', '8784', '6259', '6655', '6656', '9006', '9007', '9009', '9010', '9014', '6270', '6273', '5978', '6046', '6048', '6049', '6050', '6051', '6052', '6053', '6020', '6027', '6028', '6029', '6030', '6031', '6032', '6033', '6034', '6035', '6036', '6037', '6042', '6043', '9332', '6055', '6024', '6025', '6026', '6796', '6797', '6798', '6799', '6800', '6801', '6802', '5969', '5970', '5971', '5972', '5973', '5974', '5975', '5976', '5977', '5988', '5989', '5990', '5991', '5992', '5993', '5994', '5995', '5996', '5997', '5998', '6005', '6006', '6007', '6008', '6009', '6010', '6954', '6955', '6956', '6957', '6958', '5979', '5980', '5981', '6000', '6001', '6002', '6003', '6004', '6011', '6012', '6013', '6016', '6063', '6082', '6083', '6084', '8840', '8896', '8897', '9011', '9038', '6079', '8888', '8986', '6066', '6067', '6071', '6081', '8822', '8823', '8824', '8825', '8826', '8827', '8828', '8829', '8830', '8831', '8832', '8833', '8834', '8835', '8836', '8837', '8838', '8839', '8841', '8842', '8844', '8845', '8846', '8847', '8848', '8909', '8910', '9310', '9311', '5984', '5985', '5986', '9134', '6070', '6019', '6040', '6045', '6775', '8696', '8697', '6078', '8698', '6085', '6086', '6041', '6665', '6674', '6080', '6924', '6925', '6926', '6927', '6928', '6929', '6930', '6931', '6642', '6645', '8700', '6644', '6651', '9128', '6646', '6660', '6661', '6662', '6663', '6664', '6666', '6669', '6670', '6671', '6647', '6654', '6653', '6657', '6667', '6668', '6684', '6685', '6686', '6687', '6688', '6689', '6690', '6675', '6676', '6677', '6678', '6679', '6680', '8404', '8405', '9423', '6681', '6682', '6683', '6691', '6692', '6693', '6694', '6695', '6696', '6697', '6698', '6706', '6710', '6711', '6716', '6718', '6712', '6713', '6714', '6715', '6717', '6732', '6733', '6734', '6735', '6740', '6741', '6736', '6783', '6784', '6785', '6786', '6787', '6788', '6789', '6790', '6791', '6792', '6793', '6794', '6795', '6747', '6748', '6749', '6750', '6751', '6755', '6756', '6757', '6758', '6759', '6770', '6771', '6772', '6774', '6776', '6777', '6780', '6738', '6739', '6809', '6810', '8122', '6816', '6817', '6818', '6820', '6821', '6824', '6825', '6829', '6830', '6827', '6832', '6833', '6834', '6835', '6836', '6837', '6838', '6839', '6840', '6849', '6850', '6851', '6887', '9217', '9218', '9219', '9220', '9221', '9222', '9223', '6852', '6853', '6854', '6855', '6856', '6857', '6858', '6859', '6860', '6861', '6862', '6863', '6864', '8646', '6865', '6866', '6867', '6868', '6869', '6870', '6871', '6872', '6873', '6874', '6875', '6876', '6877', '6878', '6879', '6880', '6881', '6882', '6883', '6884', '6885', '6886', '6906', '6907', '6908', '6909', '6910', '6911', '6912', '6913', '6914', '6915', '6916', '6917', '6918', '6949', '6950', '6951', '6952', '6953', '8616', '8617', '8618', '8619', '8620', '8621', '8622', '8623', '8624', '8625', '8626', '8627', '8628', '8629', '8631', '8634', '8635', '8636', '8637', '8644', '8645', '8647', '8648', '6888', '6889', '6890', '6891', '6892', '6893', '6897', '6898', '6899', '6900', '6901', '6902', '6948', '8649', '6903', '6904', '6905', '6920', '6921', '6922', '6923', '8419', '8420', '8421', '8422', '8423', '8424', '8425', '8426', '8427', '8428', '8429', '8430', '8431', '8432', '8433', '8434', '8435', '8436', '8437', '8438', '8439', '8440', '8441', '8442', '8323', '8458', '9463', '8480', '8481', '8482', '8483', '8484', '8485', '8486', '8487', '8632', '8638', '8639', '8640', '8641', '8642', '8643', '8651', '9224', '9225', '9226', '9227', '9260', '9261', '9262', '9263', '9264', '9265', '9266', '9267', '9268', '9269', '9270', '9271', '9272', '9273', '9274', '9275', '9276', '9277', '9278', '9279', '9280', '9281', '9282', '9283', '9284'))) or `offer_for` = '0')
select distinct product_option_values.option_value_id as filter_value_id,option_value_languages.text as name from `product_option_values` inner join `option_value_languages` on `option_value_languages`.`option_value_id` = `product_option_values`.`option_value_id` where exists (select * from `product_options` where `product_option_values`.`product_option_id` = `product_options`.`id` and `product_id` in ('5967', '5968', '5982', '5983', '5999', '6021', '6023', '6038', '6039', '6047', '6054', '6068', '6699', '6701', '6704', '6705', '6707', '6708', '6709', '6726', '6727', '6728', '6729', '6730', '6731', '6762', '6763', '6804', '6805', '6806', '6807', '6808', '6811', '6812', '6813', '6814', '6815', '6819', '6822', '6823', '6826', '6831', '6841', '6842', '6843', '6844', '6847', '6848', '6932', '6933', '6934', '6935', '6936', '6937', '6939', '6940', '6941', '6942', '6943', '6944', '6945', '6946', '6947', '7195', '7196', '7197', '7198', '7199', '7200', '7201', '7202', '7203', '7204', '7205', '7206', '7207', '7208', '7209', '7210', '7211', '7212', '7213', '7214', '7215', '8166', '8189', '8241', '8242', '8243', '8244', '8245', '8246', '8251', '8252', '8464', '8633', '8650', '8666', '8667', '8668', '8669', '8670', '8671', '8672', '8673', '8674', '8675', '8676', '8677', '8678', '8679', '8680', '8681', '8682', '8699', '8730', '8731', '8766', '8771', '8772', '8773', '8843', '8876', '8891', '8892', '8893', '8894', '8895', '8933', '8934', '8935', '8969', '8983', '8984', '8987', '8988', '8990', '8991', '8992', '8993', '8994', '8995', '8996', '8997', '8998', '9013', '9015', '9022', '9024', '9025', '9026', '9027', '9039', '9076', '9077', '9078', '9079', '9080', '9081', '9083', '9084', '9085', '9086', '9087', '9088', '9089', '9090', '9091', '9098', '9099', '9100', '9101', '9102', '9103', '9120', '9122', '9124', '9125', '9126', '9206', '9207', '9208', '9209', '9210', '9211', '9212', '9213', '9214', '9215', '9230', '9364', '9365', '9369', '9370', '9371', '9376', '9377', '9378', '9393', '9394', '9395', '9396', '9397', '9398', '9399', '9400', '9406', '9408', '9409', '9410', '9411', '9412', '9430', '9432', '9433', '9434', '9436', '9437', '9438', '9439', '9440', '9441', '9442', '9443', '9444', '9445', '9446', '9447', '5952', '6773', '5953', '5954', '5955', '5956', '5957', '5958', '6056', '6088', '6165', '6167', '6199', '6205', '6309', '6648', '8739', '8853', '8985', '9028', '9029', '9030', '9117', '9287', '9288', '9289', '5959', '5960', '6089', '6764', '6765', '6766', '6767', '6778', '6779', '6803', '6895', '6896', '8097', '8098', '8099', '8100', '8101', '8102', '8103', '8931', '9048', '9049', '9050', '9129', '5962', '6090', '6077', '8290', '5966', '6742', '6743', '6781', '9133', '6672', '6161', '6162', '6174', '6175', '6181', '6218', '6219', '6220', '6221', '6222', '6223', '6224', '6225', '6226', '6227', '6228', '6230', '6231', '6232', '6233', '6234', '6235', '6236', '6237', '6238', '6239', '6284', '6290', '6293', '6294', '6301', '6304', '6643', '6652', '6719', '6720', '6724', '8764', '8765', '8889', '8890', '8930', '9008', '9018', '9019', '9034', '9035', '9036', '9037', '9118', '9119', '6163', '6017', '6018', '6044', '6059', '6164', '6176', '6177', '6178', '6179', '6180', '6182', '6262', '6263', '6264', '6265', '6266', '6267', '6268', '6269', '6278', '6280', '6283', '6287', '6292', '6302', '6305', '6306', '6721', '6722', '6723', '8701', '8851', '6058', '6099', '6169', '6260', '6658', '6659', '6673', '6171', '6213', '9040', '9041', '9042', '9043', '9044', '9045', '9046', '6166', '6649', '6650', '8703', '8849', '8850', '8852', '8861', '9032', '9033', '9127', '9131', '9366', '9367', '9368', '9380', '6091', '6092', '6093', '6094', '6095', '6096', '6097', '6098', '6172', '6173', '6100', '6193', '6194', '6195', '6196', '6197', '6198', '6208', '6209', '6073', '6074', '6242', '6243', '6244', '6245', '6246', '6247', '6248', '6249', '6250', '6251', '6252', '6253', '6254', '6255', '6307', '8702', '8936', '8989', '9121', '9372', '9373', '9374', '9375', '9379', '6256', '6257', '6184', '6185', '6186', '6187', '6188', '6189', '6191', '6192', '8035', '8036', '8919', '8920', '6210', '6211', '6212', '8932', '6087', '6240', '6241', '8784', '6259', '6655', '6656', '9006', '9007', '9009', '9010', '9014', '6270', '6273', '5978', '6046', '6048', '6049', '6050', '6051', '6052', '6053', '6020', '6027', '6028', '6029', '6030', '6031', '6032', '6033', '6034', '6035', '6036', '6037', '6042', '6043', '9332', '6055', '6024', '6025', '6026', '6796', '6797', '6798', '6799', '6800', '6801', '6802', '5969', '5970', '5971', '5972', '5973', '5974', '5975', '5976', '5977', '5988', '5989', '5990', '5991', '5992', '5993', '5994', '5995', '5996', '5997', '5998', '6005', '6006', '6007', '6008', '6009', '6010', '6954', '6955', '6956', '6957', '6958', '5979', '5980', '5981', '6000', '6001', '6002', '6003', '6004', '6011', '6012', '6013', '6016', '6063', '6082', '6083', '6084', '8840', '8896', '8897', '9011', '9038', '6079', '8888', '8986', '6066', '6067', '6071', '6081', '8822', '8823', '8824', '8825', '8826', '8827', '8828', '8829', '8830', '8831', '8832', '8833', '8834', '8835', '8836', '8837', '8838', '8839', '8841', '8842', '8844', '8845', '8846', '8847', '8848', '8909', '8910', '9310', '9311', '5984', '5985', '5986', '9134', '6070', '6019', '6040', '6045', '6775', '8696', '8697', '6078', '8698', '6085', '6086', '6041', '6665', '6674', '6080', '6924', '6925', '6926', '6927', '6928', '6929', '6930', '6931', '6642', '6645', '8700', '6644', '6651', '9128', '6646', '6660', '6661', '6662', '6663', '6664', '6666', '6669', '6670', '6671', '6647', '6654', '6653', '6657', '6667', '6668', '6684', '6685', '6686', '6687', '6688', '6689', '6690', '6675', '6676', '6677', '6678', '6679', '6680', '8404', '8405', '9423', '6681', '6682', '6683', '6691', '6692', '6693', '6694', '6695', '6696', '6697', '6698', '6706', '6710', '6711', '6716', '6718', '6712', '6713', '6714', '6715', '6717', '6732', '6733', '6734', '6735', '6740', '6741', '6736', '6783', '6784', '6785', '6786', '6787', '6788', '6789', '6790', '6791', '6792', '6793', '6794', '6795', '6747', '6748', '6749', '6750', '6751', '6755', '6756', '6757', '6758', '6759', '6770', '6771', '6772', '6774', '6776', '6777', '6780', '6738', '6739', '6809', '6810', '8122', '6816', '6817', '6818', '6820', '6821', '6824', '6825', '6829', '6830', '6827', '6832', '6833', '6834', '6835', '6836', '6837', '6838', '6839', '6840', '6849', '6850', '6851', '6887', '9217', '9218', '9219', '9220', '9221', '9222', '9223', '6852', '6853', '6854', '6855', '6856', '6857', '6858', '6859', '6860', '6861', '6862', '6863', '6864', '8646', '6865', '6866', '6867', '6868', '6869', '6870', '6871', '6872', '6873', '6874', '6875', '6876', '6877', '6878', '6879', '6880', '6881', '6882', '6883', '6884', '6885', '6886', '6906', '6907', '6908', '6909', '6910', '6911', '6912', '6913', '6914', '6915', '6916', '6917', '6918', '6949', '6950', '6951', '6952', '6953', '8616', '8617', '8618', '8619', '8620', '8621', '8622', '8623', '8624', '8625', '8626', '8627', '8628', '8629', '8631', '8634', '8635', '8636', '8637', '8644', '8645', '8647', '8648', '6888', '6889', '6890', '6891', '6892', '6893', '6897', '6898', '6899', '6900', '6901', '6902', '6948', '8649', '6903', '6904', '6905', '6920', '6921', '6922', '6923', '8419', '8420', '8421', '8422', '8423', '8424', '8425', '8426', '8427', '8428', '8429', '8430', '8431', '8432', '8433', '8434', '8435', '8436', '8437', '8438', '8439', '8440', '8441', '8442', '8323', '8458', '9463', '8480', '8481', '8482', '8483', '8484', '8485', '8486', '8487', '8632', '8638', '8639', '8640', '8641', '8642', '8643', '8651', '9224', '9225', '9226', '9227', '9260', '9261', '9262', '9263', '9264', '9265', '9266', '9267', '9268', '9269', '9270', '9271', '9272', '9273', '9274', '9275', '9276', '9277', '9278', '9279', '9280', '9281', '9282', '9283', '9284') and `option_id` = '1') and `option_value_languages`.`language_id` = '1'
select distinct product_option_values.option_value_id as filter_value_id,option_value_languages.text as name from `product_option_values` inner join `option_value_languages` on `option_value_languages`.`option_value_id` = `product_option_values`.`option_value_id` where exists (select * from `product_options` where `product_option_values`.`product_option_id` = `product_options`.`id` and `product_id` in ('5967', '5968', '5982', '5983', '5999', '6021', '6023', '6038', '6039', '6047', '6054', '6068', '6699', '6701', '6704', '6705', '6707', '6708', '6709', '6726', '6727', '6728', '6729', '6730', '6731', '6762', '6763', '6804', '6805', '6806', '6807', '6808', '6811', '6812', '6813', '6814', '6815', '6819', '6822', '6823', '6826', '6831', '6841', '6842', '6843', '6844', '6847', '6848', '6932', '6933', '6934', '6935', '6936', '6937', '6939', '6940', '6941', '6942', '6943', '6944', '6945', '6946', '6947', '7195', '7196', '7197', '7198', '7199', '7200', '7201', '7202', '7203', '7204', '7205', '7206', '7207', '7208', '7209', '7210', '7211', '7212', '7213', '7214', '7215', '8166', '8189', '8241', '8242', '8243', '8244', '8245', '8246', '8251', '8252', '8464', '8633', '8650', '8666', '8667', '8668', '8669', '8670', '8671', '8672', '8673', '8674', '8675', '8676', '8677', '8678', '8679', '8680', '8681', '8682', '8699', '8730', '8731', '8766', '8771', '8772', '8773', '8843', '8876', '8891', '8892', '8893', '8894', '8895', '8933', '8934', '8935', '8969', '8983', '8984', '8987', '8988', '8990', '8991', '8992', '8993', '8994', '8995', '8996', '8997', '8998', '9013', '9015', '9022', '9024', '9025', '9026', '9027', '9039', '9076', '9077', '9078', '9079', '9080', '9081', '9083', '9084', '9085', '9086', '9087', '9088', '9089', '9090', '9091', '9098', '9099', '9100', '9101', '9102', '9103', '9120', '9122', '9124', '9125', '9126', '9206', '9207', '9208', '9209', '9210', '9211', '9212', '9213', '9214', '9215', '9230', '9364', '9365', '9369', '9370', '9371', '9376', '9377', '9378', '9393', '9394', '9395', '9396', '9397', '9398', '9399', '9400', '9406', '9408', '9409', '9410', '9411', '9412', '9430', '9432', '9433', '9434', '9436', '9437', '9438', '9439', '9440', '9441', '9442', '9443', '9444', '9445', '9446', '9447', '5952', '6773', '5953', '5954', '5955', '5956', '5957', '5958', '6056', '6088', '6165', '6167', '6199', '6205', '6309', '6648', '8739', '8853', '8985', '9028', '9029', '9030', '9117', '9287', '9288', '9289', '5959', '5960', '6089', '6764', '6765', '6766', '6767', '6778', '6779', '6803', '6895', '6896', '8097', '8098', '8099', '8100', '8101', '8102', '8103', '8931', '9048', '9049', '9050', '9129', '5962', '6090', '6077', '8290', '5966', '6742', '6743', '6781', '9133', '6672', '6161', '6162', '6174', '6175', '6181', '6218', '6219', '6220', '6221', '6222', '6223', '6224', '6225', '6226', '6227', '6228', '6230', '6231', '6232', '6233', '6234', '6235', '6236', '6237', '6238', '6239', '6284', '6290', '6293', '6294', '6301', '6304', '6643', '6652', '6719', '6720', '6724', '8764', '8765', '8889', '8890', '8930', '9008', '9018', '9019', '9034', '9035', '9036', '9037', '9118', '9119', '6163', '6017', '6018', '6044', '6059', '6164', '6176', '6177', '6178', '6179', '6180', '6182', '6262', '6263', '6264', '6265', '6266', '6267', '6268', '6269', '6278', '6280', '6283', '6287', '6292', '6302', '6305', '6306', '6721', '6722', '6723', '8701', '8851', '6058', '6099', '6169', '6260', '6658', '6659', '6673', '6171', '6213', '9040', '9041', '9042', '9043', '9044', '9045', '9046', '6166', '6649', '6650', '8703', '8849', '8850', '8852', '8861', '9032', '9033', '9127', '9131', '9366', '9367', '9368', '9380', '6091', '6092', '6093', '6094', '6095', '6096', '6097', '6098', '6172', '6173', '6100', '6193', '6194', '6195', '6196', '6197', '6198', '6208', '6209', '6073', '6074', '6242', '6243', '6244', '6245', '6246', '6247', '6248', '6249', '6250', '6251', '6252', '6253', '6254', '6255', '6307', '8702', '8936', '8989', '9121', '9372', '9373', '9374', '9375', '9379', '6256', '6257', '6184', '6185', '6186', '6187', '6188', '6189', '6191', '6192', '8035', '8036', '8919', '8920', '6210', '6211', '6212', '8932', '6087', '6240', '6241', '8784', '6259', '6655', '6656', '9006', '9007', '9009', '9010', '9014', '6270', '6273', '5978', '6046', '6048', '6049', '6050', '6051', '6052', '6053', '6020', '6027', '6028', '6029', '6030', '6031', '6032', '6033', '6034', '6035', '6036', '6037', '6042', '6043', '9332', '6055', '6024', '6025', '6026', '6796', '6797', '6798', '6799', '6800', '6801', '6802', '5969', '5970', '5971', '5972', '5973', '5974', '5975', '5976', '5977', '5988', '5989', '5990', '5991', '5992', '5993', '5994', '5995', '5996', '5997', '5998', '6005', '6006', '6007', '6008', '6009', '6010', '6954', '6955', '6956', '6957', '6958', '5979', '5980', '5981', '6000', '6001', '6002', '6003', '6004', '6011', '6012', '6013', '6016', '6063', '6082', '6083', '6084', '8840', '8896', '8897', '9011', '9038', '6079', '8888', '8986', '6066', '6067', '6071', '6081', '8822', '8823', '8824', '8825', '8826', '8827', '8828', '8829', '8830', '8831', '8832', '8833', '8834', '8835', '8836', '8837', '8838', '8839', '8841', '8842', '8844', '8845', '8846', '8847', '8848', '8909', '8910', '9310', '9311', '5984', '5985', '5986', '9134', '6070', '6019', '6040', '6045', '6775', '8696', '8697', '6078', '8698', '6085', '6086', '6041', '6665', '6674', '6080', '6924', '6925', '6926', '6927', '6928', '6929', '6930', '6931', '6642', '6645', '8700', '6644', '6651', '9128', '6646', '6660', '6661', '6662', '6663', '6664', '6666', '6669', '6670', '6671', '6647', '6654', '6653', '6657', '6667', '6668', '6684', '6685', '6686', '6687', '6688', '6689', '6690', '6675', '6676', '6677', '6678', '6679', '6680', '8404', '8405', '9423', '6681', '6682', '6683', '6691', '6692', '6693', '6694', '6695', '6696', '6697', '6698', '6706', '6710', '6711', '6716', '6718', '6712', '6713', '6714', '6715', '6717', '6732', '6733', '6734', '6735', '6740', '6741', '6736', '6783', '6784', '6785', '6786', '6787', '6788', '6789', '6790', '6791', '6792', '6793', '6794', '6795', '6747', '6748', '6749', '6750', '6751', '6755', '6756', '6757', '6758', '6759', '6770', '6771', '6772', '6774', '6776', '6777', '6780', '6738', '6739', '6809', '6810', '8122', '6816', '6817', '6818', '6820', '6821', '6824', '6825', '6829', '6830', '6827', '6832', '6833', '6834', '6835', '6836', '6837', '6838', '6839', '6840', '6849', '6850', '6851', '6887', '9217', '9218', '9219', '9220', '9221', '9222', '9223', '6852', '6853', '6854', '6855', '6856', '6857', '6858', '6859', '6860', '6861', '6862', '6863', '6864', '8646', '6865', '6866', '6867', '6868', '6869', '6870', '6871', '6872', '6873', '6874', '6875', '6876', '6877', '6878', '6879', '6880', '6881', '6882', '6883', '6884', '6885', '6886', '6906', '6907', '6908', '6909', '6910', '6911', '6912', '6913', '6914', '6915', '6916', '6917', '6918', '6949', '6950', '6951', '6952', '6953', '8616', '8617', '8618', '8619', '8620', '8621', '8622', '8623', '8624', '8625', '8626', '8627', '8628', '8629', '8631', '8634', '8635', '8636', '8637', '8644', '8645', '8647', '8648', '6888', '6889', '6890', '6891', '6892', '6893', '6897', '6898', '6899', '6900', '6901', '6902', '6948', '8649', '6903', '6904', '6905', '6920', '6921', '6922', '6923', '8419', '8420', '8421', '8422', '8423', '8424', '8425', '8426', '8427', '8428', '8429', '8430', '8431', '8432', '8433', '8434', '8435', '8436', '8437', '8438', '8439', '8440', '8441', '8442', '8323', '8458', '9463', '8480', '8481', '8482', '8483', '8484', '8485', '8486', '8487', '8632', '8638', '8639', '8640', '8641', '8642', '8643', '8651', '9224', '9225', '9226', '9227', '9260', '9261', '9262', '9263', '9264', '9265', '9266', '9267', '9268', '9269', '9270', '9271', '9272', '9273', '9274', '9275', '9276', '9277', '9278', '9279', '9280', '9281', '9282', '9283', '9284') and `option_id` = '16') and `option_value_languages`.`language_id` = '1'
select * from `product_specification_values` where exists (select * from `product_specifications` where `product_specification_values`.`product_specification_id` = `product_specifications`.`id` and `product_id` in ('5967', '5968', '5982', '5983', '5999', '6021', '6023', '6038', '6039', '6047', '6054', '6068', '6699', '6701', '6704', '6705', '6707', '6708', '6709', '6726', '6727', '6728', '6729', '6730', '6731', '6762', '6763', '6804', '6805', '6806', '6807', '6808', '6811', '6812', '6813', '6814', '6815', '6819', '6822', '6823', '6826', '6831', '6841', '6842', '6843', '6844', '6847', '6848', '6932', '6933', '6934', '6935', '6936', '6937', '6939', '6940', '6941', '6942', '6943', '6944', '6945', '6946', '6947', '7195', '7196', '7197', '7198', '7199', '7200', '7201', '7202', '7203', '7204', '7205', '7206', '7207', '7208', '7209', '7210', '7211', '7212', '7213', '7214', '7215', '8166', '8189', '8241', '8242', '8243', '8244', '8245', '8246', '8251', '8252', '8464', '8633', '8650', '8666', '8667', '8668', '8669', '8670', '8671', '8672', '8673', '8674', '8675', '8676', '8677', '8678', '8679', '8680', '8681', '8682', '8699', '8730', '8731', '8766', '8771', '8772', '8773', '8843', '8876', '8891', '8892', '8893', '8894', '8895', '8933', '8934', '8935', '8969', '8983', '8984', '8987', '8988', '8990', '8991', '8992', '8993', '8994', '8995', '8996', '8997', '8998', '9013', '9015', '9022', '9024', '9025', '9026', '9027', '9039', '9076', '9077', '9078', '9079', '9080', '9081', '9083', '9084', '9085', '9086', '9087', '9088', '9089', '9090', '9091', '9098', '9099', '9100', '9101', '9102', '9103', '9120', '9122', '9124', '9125', '9126', '9206', '9207', '9208', '9209', '9210', '9211', '9212', '9213', '9214', '9215', '9230', '9364', '9365', '9369', '9370', '9371', '9376', '9377', '9378', '9393', '9394', '9395', '9396', '9397', '9398', '9399', '9400', '9406', '9408', '9409', '9410', '9411', '9412', '9430', '9432', '9433', '9434', '9436', '9437', '9438', '9439', '9440', '9441', '9442', '9443', '9444', '9445', '9446', '9447', '5952', '6773', '5953', '5954', '5955', '5956', '5957', '5958', '6056', '6088', '6165', '6167', '6199', '6205', '6309', '6648', '8739', '8853', '8985', '9028', '9029', '9030', '9117', '9287', '9288', '9289', '5959', '5960', '6089', '6764', '6765', '6766', '6767', '6778', '6779', '6803', '6895', '6896', '8097', '8098', '8099', '8100', '8101', '8102', '8103', '8931', '9048', '9049', '9050', '9129', '5962', '6090', '6077', '8290', '5966', '6742', '6743', '6781', '9133', '6672', '6161', '6162', '6174', '6175', '6181', '6218', '6219', '6220', '6221', '6222', '6223', '6224', '6225', '6226', '6227', '6228', '6230', '6231', '6232', '6233', '6234', '6235', '6236', '6237', '6238', '6239', '6284', '6290', '6293', '6294', '6301', '6304', '6643', '6652', '6719', '6720', '6724', '8764', '8765', '8889', '8890', '8930', '9008', '9018', '9019', '9034', '9035', '9036', '9037', '9118', '9119', '6163', '6017', '6018', '6044', '6059', '6164', '6176', '6177', '6178', '6179', '6180', '6182', '6262', '6263', '6264', '6265', '6266', '6267', '6268', '6269', '6278', '6280', '6283', '6287', '6292', '6302', '6305', '6306', '6721', '6722', '6723', '8701', '8851', '6058', '6099', '6169', '6260', '6658', '6659', '6673', '6171', '6213', '9040', '9041', '9042', '9043', '9044', '9045', '9046', '6166', '6649', '6650', '8703', '8849', '8850', '8852', '8861', '9032', '9033', '9127', '9131', '9366', '9367', '9368', '9380', '6091', '6092', '6093', '6094', '6095', '6096', '6097', '6098', '6172', '6173', '6100', '6193', '6194', '6195', '6196', '6197', '6198', '6208', '6209', '6073', '6074', '6242', '6243', '6244', '6245', '6246', '6247', '6248', '6249', '6250', '6251', '6252', '6253', '6254', '6255', '6307', '8702', '8936', '8989', '9121', '9372', '9373', '9374', '9375', '9379', '6256', '6257', '6184', '6185', '6186', '6187', '6188', '6189', '6191', '6192', '8035', '8036', '8919', '8920', '6210', '6211', '6212', '8932', '6087', '6240', '6241', '8784', '6259', '6655', '6656', '9006', '9007', '9009', '9010', '9014', '6270', '6273', '5978', '6046', '6048', '6049', '6050', '6051', '6052', '6053', '6020', '6027', '6028', '6029', '6030', '6031', '6032', '6033', '6034', '6035', '6036', '6037', '6042', '6043', '9332', '6055', '6024', '6025', '6026', '6796', '6797', '6798', '6799', '6800', '6801', '6802', '5969', '5970', '5971', '5972', '5973', '5974', '5975', '5976', '5977', '5988', '5989', '5990', '5991', '5992', '5993', '5994', '5995', '5996', '5997', '5998', '6005', '6006', '6007', '6008', '6009', '6010', '6954', '6955', '6956', '6957', '6958', '5979', '5980', '5981', '6000', '6001', '6002', '6003', '6004', '6011', '6012', '6013', '6016', '6063', '6082', '6083', '6084', '8840', '8896', '8897', '9011', '9038', '6079', '8888', '8986', '6066', '6067', '6071', '6081', '8822', '8823', '8824', '8825', '8826', '8827', '8828', '8829', '8830', '8831', '8832', '8833', '8834', '8835', '8836', '8837', '8838', '8839', '8841', '8842', '8844', '8845', '8846', '8847', '8848', '8909', '8910', '9310', '9311', '5984', '5985', '5986', '9134', '6070', '6019', '6040', '6045', '6775', '8696', '8697', '6078', '8698', '6085', '6086', '6041', '6665', '6674', '6080', '6924', '6925', '6926', '6927', '6928', '6929', '6930', '6931', '6642', '6645', '8700', '6644', '6651', '9128', '6646', '6660', '6661', '6662', '6663', '6664', '6666', '6669', '6670', '6671', '6647', '6654', '6653', '6657', '6667', '6668', '6684', '6685', '6686', '6687', '6688', '6689', '6690', '6675', '6676', '6677', '6678', '6679', '6680', '8404', '8405', '9423', '6681', '6682', '6683', '6691', '6692', '6693', '6694', '6695', '6696', '6697', '6698', '6706', '6710', '6711', '6716', '6718', '6712', '6713', '6714', '6715', '6717', '6732', '6733', '6734', '6735', '6740', '6741', '6736', '6783', '6784', '6785', '6786', '6787', '6788', '6789', '6790', '6791', '6792', '6793', '6794', '6795', '6747', '6748', '6749', '6750', '6751', '6755', '6756', '6757', '6758', '6759', '6770', '6771', '6772', '6774', '6776', '6777', '6780', '6738', '6739', '6809', '6810', '8122', '6816', '6817', '6818', '6820', '6821', '6824', '6825', '6829', '6830', '6827', '6832', '6833', '6834', '6835', '6836', '6837', '6838', '6839', '6840', '6849', '6850', '6851', '6887', '9217', '9218', '9219', '9220', '9221', '9222', '9223', '6852', '6853', '6854', '6855', '6856', '6857', '6858', '6859', '6860', '6861', '6862', '6863', '6864', '8646', '6865', '6866', '6867', '6868', '6869', '6870', '6871', '6872', '6873', '6874', '6875', '6876', '6877', '6878', '6879', '6880', '6881', '6882', '6883', '6884', '6885', '6886', '6906', '6907', '6908', '6909', '6910', '6911', '6912', '6913', '6914', '6915', '6916', '6917', '6918', '6949', '6950', '6951', '6952', '6953', '8616', '8617', '8618', '8619', '8620', '8621', '8622', '8623', '8624', '8625', '8626', '8627', '8628', '8629', '8631', '8634', '8635', '8636', '8637', '8644', '8645', '8647', '8648', '6888', '6889', '6890', '6891', '6892', '6893', '6897', '6898', '6899', '6900', '6901', '6902', '6948', '8649', '6903', '6904', '6905', '6920', '6921', '6922', '6923', '8419', '8420', '8421', '8422', '8423', '8424', '8425', '8426', '8427', '8428', '8429', '8430', '8431', '8432', '8433', '8434', '8435', '8436', '8437', '8438', '8439', '8440', '8441', '8442', '8323', '8458', '9463', '8480', '8481', '8482', '8483', '8484', '8485', '8486', '8487', '8632', '8638', '8639', '8640', '8641', '8642', '8643', '8651', '9224', '9225', '9226', '9227', '9260', '9261', '9262', '9263', '9264', '9265', '9266', '9267', '9268', '9269', '9270', '9271', '9272', '9273', '9274', '9275', '9276', '9277', '9278', '9279', '9280', '9281', '9282', '9283', '9284'))
select distinct specifications.id,specifications.id as filter_value_id, specification_languages.name from `products` inner join `product_specifications` on `products`.`id` = `product_specifications`.`product_id` inner join `specification_languages` on `specification_languages`.`specification_id` = `product_specifications`.`specification_id` inner join `specifications` on `specifications`.`id` = `product_specifications`.`specification_id` where `products`.`id` in ('5967', '5968', '5982', '5983', '5999', '6021', '6023', '6038', '6039', '6047', '6054', '6068', '6699', '6701', '6704', '6705', '6707', '6708', '6709', '6726', '6727', '6728', '6729', '6730', '6731', '6762', '6763', '6804', '6805', '6806', '6807', '6808', '6811', '6812', '6813', '6814', '6815', '6819', '6822', '6823', '6826', '6831', '6841', '6842', '6843', '6844', '6847', '6848', '6932', '6933', '6934', '6935', '6936', '6937', '6939', '6940', '6941', '6942', '6943', '6944', '6945', '6946', '6947', '7195', '7196', '7197', '7198', '7199', '7200', '7201', '7202', '7203', '7204', '7205', '7206', '7207', '7208', '7209', '7210', '7211', '7212', '7213', '7214', '7215', '8166', '8189', '8241', '8242', '8243', '8244', '8245', '8246', '8251', '8252', '8464', '8633', '8650', '8666', '8667', '8668', '8669', '8670', '8671', '8672', '8673', '8674', '8675', '8676', '8677', '8678', '8679', '8680', '8681', '8682', '8699', '8730', '8731', '8766', '8771', '8772', '8773', '8843', '8876', '8891', '8892', '8893', '8894', '8895', '8933', '8934', '8935', '8969', '8983', '8984', '8987', '8988', '8990', '8991', '8992', '8993', '8994', '8995', '8996', '8997', '8998', '9013', '9015', '9022', '9024', '9025', '9026', '9027', '9039', '9076', '9077', '9078', '9079', '9080', '9081', '9083', '9084', '9085', '9086', '9087', '9088', '9089', '9090', '9091', '9098', '9099', '9100', '9101', '9102', '9103', '9120', '9122', '9124', '9125', '9126', '9206', '9207', '9208', '9209', '9210', '9211', '9212', '9213', '9214', '9215', '9230', '9364', '9365', '9369', '9370', '9371', '9376', '9377', '9378', '9393', '9394', '9395', '9396', '9397', '9398', '9399', '9400', '9406', '9408', '9409', '9410', '9411', '9412', '9430', '9432', '9433', '9434', '9436', '9437', '9438', '9439', '9440', '9441', '9442', '9443', '9444', '9445', '9446', '9447', '5952', '6773', '5953', '5954', '5955', '5956', '5957', '5958', '6056', '6088', '6165', '6167', '6199', '6205', '6309', '6648', '8739', '8853', '8985', '9028', '9029', '9030', '9117', '9287', '9288', '9289', '5959', '5960', '6089', '6764', '6765', '6766', '6767', '6778', '6779', '6803', '6895', '6896', '8097', '8098', '8099', '8100', '8101', '8102', '8103', '8931', '9048', '9049', '9050', '9129', '5962', '6090', '6077', '8290', '5966', '6742', '6743', '6781', '9133', '6672', '6161', '6162', '6174', '6175', '6181', '6218', '6219', '6220', '6221', '6222', '6223', '6224', '6225', '6226', '6227', '6228', '6230', '6231', '6232', '6233', '6234', '6235', '6236', '6237', '6238', '6239', '6284', '6290', '6293', '6294', '6301', '6304', '6643', '6652', '6719', '6720', '6724', '8764', '8765', '8889', '8890', '8930', '9008', '9018', '9019', '9034', '9035', '9036', '9037', '9118', '9119', '6163', '6017', '6018', '6044', '6059', '6164', '6176', '6177', '6178', '6179', '6180', '6182', '6262', '6263', '6264', '6265', '6266', '6267', '6268', '6269', '6278', '6280', '6283', '6287', '6292', '6302', '6305', '6306', '6721', '6722', '6723', '8701', '8851', '6058', '6099', '6169', '6260', '6658', '6659', '6673', '6171', '6213', '9040', '9041', '9042', '9043', '9044', '9045', '9046', '6166', '6649', '6650', '8703', '8849', '8850', '8852', '8861', '9032', '9033', '9127', '9131', '9366', '9367', '9368', '9380', '6091', '6092', '6093', '6094', '6095', '6096', '6097', '6098', '6172', '6173', '6100', '6193', '6194', '6195', '6196', '6197', '6198', '6208', '6209', '6073', '6074', '6242', '6243', '6244', '6245', '6246', '6247', '6248', '6249', '6250', '6251', '6252', '6253', '6254', '6255', '6307', '8702', '8936', '8989', '9121', '9372', '9373', '9374', '9375', '9379', '6256', '6257', '6184', '6185', '6186', '6187', '6188', '6189', '6191', '6192', '8035', '8036', '8919', '8920', '6210', '6211', '6212', '8932', '6087', '6240', '6241', '8784', '6259', '6655', '6656', '9006', '9007', '9009', '9010', '9014', '6270', '6273', '5978', '6046', '6048', '6049', '6050', '6051', '6052', '6053', '6020', '6027', '6028', '6029', '6030', '6031', '6032', '6033', '6034', '6035', '6036', '6037', '6042', '6043', '9332', '6055', '6024', '6025', '6026', '6796', '6797', '6798', '6799', '6800', '6801', '6802', '5969', '5970', '5971', '5972', '5973', '5974', '5975', '5976', '5977', '5988', '5989', '5990', '5991', '5992', '5993', '5994', '5995', '5996', '5997', '5998', '6005', '6006', '6007', '6008', '6009', '6010', '6954', '6955', '6956', '6957', '6958', '5979', '5980', '5981', '6000', '6001', '6002', '6003', '6004', '6011', '6012', '6013', '6016', '6063', '6082', '6083', '6084', '8840', '8896', '8897', '9011', '9038', '6079', '8888', '8986', '6066', '6067', '6071', '6081', '8822', '8823', '8824', '8825', '8826', '8827', '8828', '8829', '8830', '8831', '8832', '8833', '8834', '8835', '8836', '8837', '8838', '8839', '8841', '8842', '8844', '8845', '8846', '8847', '8848', '8909', '8910', '9310', '9311', '5984', '5985', '5986', '9134', '6070', '6019', '6040', '6045', '6775', '8696', '8697', '6078', '8698', '6085', '6086', '6041', '6665', '6674', '6080', '6924', '6925', '6926', '6927', '6928', '6929', '6930', '6931', '6642', '6645', '8700', '6644', '6651', '9128', '6646', '6660', '6661', '6662', '6663', '6664', '6666', '6669', '6670', '6671', '6647', '6654', '6653', '6657', '6667', '6668', '6684', '6685', '6686', '6687', '6688', '6689', '6690', '6675', '6676', '6677', '6678', '6679', '6680', '8404', '8405', '9423', '6681', '6682', '6683', '6691', '6692', '6693', '6694', '6695', '6696', '6697', '6698', '6706', '6710', '6711', '6716', '6718', '6712', '6713', '6714', '6715', '6717', '6732', '6733', '6734', '6735', '6740', '6741', '6736', '6783', '6784', '6785', '6786', '6787', '6788', '6789', '6790', '6791', '6792', '6793', '6794', '6795', '6747', '6748', '6749', '6750', '6751', '6755', '6756', '6757', '6758', '6759', '6770', '6771', '6772', '6774', '6776', '6777', '6780', '6738', '6739', '6809', '6810', '8122', '6816', '6817', '6818', '6820', '6821', '6824', '6825', '6829', '6830', '6827', '6832', '6833', '6834', '6835', '6836', '6837', '6838', '6839', '6840', '6849', '6850', '6851', '6887', '9217', '9218', '9219', '9220', '9221', '9222', '9223', '6852', '6853', '6854', '6855', '6856', '6857', '6858', '6859', '6860', '6861', '6862', '6863', '6864', '8646', '6865', '6866', '6867', '6868', '6869', '6870', '6871', '6872', '6873', '6874', '6875', '6876', '6877', '6878', '6879', '6880', '6881', '6882', '6883', '6884', '6885', '6886', '6906', '6907', '6908', '6909', '6910', '6911', '6912', '6913', '6914', '6915', '6916', '6917', '6918', '6949', '6950', '6951', '6952', '6953', '8616', '8617', '8618', '8619', '8620', '8621', '8622', '8623', '8624', '8625', '8626', '8627', '8628', '8629', '8631', '8634', '8635', '8636', '8637', '8644', '8645', '8647', '8648', '6888', '6889', '6890', '6891', '6892', '6893', '6897', '6898', '6899', '6900', '6901', '6902', '6948', '8649', '6903', '6904', '6905', '6920', '6921', '6922', '6923', '8419', '8420', '8421', '8422', '8423', '8424', '8425', '8426', '8427', '8428', '8429', '8430', '8431', '8432', '8433', '8434', '8435', '8436', '8437', '8438', '8439', '8440', '8441', '8442', '8323', '8458', '9463', '8480', '8481', '8482', '8483', '8484', '8485', '8486', '8487', '8632', '8638', '8639', '8640', '8641', '8642', '8643', '8651', '9224', '9225', '9226', '9227', '9260', '9261', '9262', '9263', '9264', '9265', '9266', '9267', '9268', '9269', '9270', '9271', '9272', '9273', '9274', '9275', '9276', '9277', '9278', '9279', '9280', '9281', '9282', '9283', '9284') and (`in_filter` = '1' and `specification_languages`.`language_id` = '1') and `products`.`deleted_at` is null
select * from `banners` inner join `banner_languages` on `banners`.`id` = `banner_languages`.`banner_id` inner join `languages` on `languages`.`id` = `banner_languages`.`language_id` where (`start_time` <= '2025-07-06 13:14:12' or `start_time` is null) and (`end_time` >= '2025-07-06 13:14:12' or `end_time` is null) and (`is_active` = '1' and `banner_type_id` = '10') and `languages`.`code` = 'en' order by `order_number` asc
select * from `website_banners` inner join `website_banner_languages` on `website_banners`.`id` = `website_banner_languages`.`banner_id` inner join `languages` on `languages`.`id` = `website_banner_languages`.`language_id` where exists (select * from `website_banner_types` where `website_banners`.`banner_type_id` = `website_banner_types`.`id` and `status` = '1') and (`start_time` <= '2025-07-06 13:14:12' or `start_time` is null) and (`end_time` >= '2025-07-06 13:14:12' or `end_time` is null) and (`is_active` = '1') and `languages`.`code` = 'en' and `banner_type_id` in ('19', '20', '21')