تولید، تامین و اجرای سیستم های تهویه مطبوع و اتوماسیون پیشرفته
products
currency
category
category_list
obLevel
__env
app
setting
errors
__currentLoopData
row
i
loop
r
k
data
product
download_category
product_category
page_category
page
services
article_category
project_category
social
customers
select * from `products_category` where `products_category`.`id` = '94' limit 1
SELECT *
LIMIT
ORDER BY
select * from `currency` where `status` = '1'
select * from `products` where `category_main_id` = '94' and `status` = '1' and `products`.`deleted_at` is null order by `not_available` asc, `call_us` asc, `call_us` desc, `not_available` desc, `listorder` asc
select * from `products_category` where `parent_id` is null and `status` = '1' order by `listorder` asc
select * from `products_category_language` where `products_category_language`.`product_category_id` = '94' and `products_category_language`.`product_category_id` is not null limit 1
select * from `products_category` where `products_category`.`id` = '6' and `products_category`.`id` is not null limit 1
select * from `products_category` where `products_category`.`parent_id` = '6' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '91' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '92' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '106' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '107' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '108' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '93' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '94' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '95' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '96' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_language` where `products_language`.`product_id` = '112' and `products_language`.`product_id` is not null limit 1
select * from `products_language` where `products_language`.`product_id` = '113' and `products_language`.`product_id` is not null limit 1
select * from `products_language` where `products_language`.`product_id` = '114' and `products_language`.`product_id` is not null limit 1
select * from `setting_language` where `setting_language`.`setting_id` = '1' and `setting_language`.`setting_id` is not null limit 1
select * from `contents` where `status` = '1' and `content_type_id` = '4' and `show_menu` = '1' order by `listorder` asc
select * from `contents_category` where `status` = '1' and `content_type_id` = '7' and `parent_id` is null and `show_menu` = '1' order by `listorder` asc
select * from `contents_category` where `status` = '1' and `content_type_id` = '5' and `parent_id` is null and `show_menu` = '1' order by `listorder` asc
select * from `page_categories` where `status` = '1' and `show_menu` = '1' and `parent_id` is null order by `created_at` desc
select * from `pages` where `status` = '1' and `show_menu` = '1' and `pages`.`category_id` in ('3') order by `created_at` desc
select * from `pages` where `status` = '1' and `show_menu` = '1' and `category_id` is null order by `listorder` asc
select * from `products_category` where `status` = '1' and `show_menu` = '1' and `parent_id` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` in ('2', '6', '7', '138', '162')
select * from `products_category` where `status` = '1' and `show_menu` = '2' and `parent_id` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` in ('134', '135')
select * from `products` where `status` = '1' and `show_menu` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `product_download_category` where `status` = '1' and `parent_id` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '162' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '2' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '24' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '24' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '25' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '25' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '26' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '26' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '28' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '28' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '27' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '27' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '29' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '29' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products` where `products`.`category_id` = '91' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products` where `products`.`category_id` = '106' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products` where `products`.`category_id` = '107' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products` where `products`.`category_id` = '108' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products` where `products`.`category_id` = '93' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products` where `products`.`category_id` = '94' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products` where `products`.`category_id` = '95' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products` where `products`.`category_id` = '96' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '138' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '139' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '139' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '140' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '140' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '141' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '141' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '142' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '142' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '143' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '150' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '150' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '7' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '137' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '152' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '152' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '153' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '153' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '154' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '154' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '123' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '159' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '159' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '156' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '156' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '157' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '157' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '158' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '158' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '129' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '146' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '149' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '149' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '160' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '155' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '155' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '151' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '151' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `products_category` where `products_category`.`parent_id` = '144' and `products_category`.`parent_id` is not null and `status` = '1' order by `listorder` asc
select * from `products` where `products`.`category_id` = '144' and `products`.`category_id` is not null and `status` = '1' and `products`.`deleted_at` is null order by `listorder` asc
select * from `product_download_category` where `product_download_category`.`parent_id` = '11' and `product_download_category`.`parent_id` is not null
select * from `product_download_category` where `product_download_category`.`parent_id` = '5' and `product_download_category`.`parent_id` is not null
select * from `product_download_category` where `product_download_category`.`parent_id` = '10' and `product_download_category`.`parent_id` is not null
select * from `product_download_category` where `product_download_category`.`parent_id` = '13' and `product_download_category`.`parent_id` is not null
select * from `product_download_category` where `product_download_category`.`parent_id` = '6' and `product_download_category`.`parent_id` is not null
select * from `pages` where `pages`.`category_id` = '3' and `pages`.`category_id` is not null
select * from `contents` where `content_type_id` = '3' and `status` = '1'
select * from `customers` where `status` = '1' order by `listorder` asc
select * from `contents_language` where `contents_language`.`content_id` = '34' and `contents_language`.`content_id` is not null limit 1
select * from `contents_language` where `contents_language`.`content_id` = '35' and `contents_language`.`content_id` is not null limit 1
select * from `contents_language` where `contents_language`.`content_id` = '37' and `contents_language`.`content_id` is not null limit 1
select * from `contents_language` where `contents_language`.`content_id` = '38' and `contents_language`.`content_id` is not null limit 1
select * from `contents_language` where `contents_language`.`content_id` = '39' and `contents_language`.`content_id` is not null limit 1