Query | Affected | Num. rows | Took (ms) | Actions |
---|
SELECT `StaticPage`.`slug` FROM `demoe3_getezquotes`.`static_pages` AS `StaticPage` WHERE 1 = 1 | 30 | 30 | 0 | |
SELECT `Country`.`slug` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE 1 = 1 | 15 | 15 | 0 | |
SELECT `Country`.`slug`, `Country`.`name`, `Country`.`id`, `Country`.`timezone` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE `is_default` = 1 ORDER BY `country_order` ASC, `name` ASC LIMIT 1 | 1 | 1 | 0 | |
SELECT `CurrencyCountry`.`currency_id`, `Currency`.`exchange_rate`, `Currency`.`code`, `Currency`.`symbol_postions` FROM `demoe3_getezquotes`.`currency_countries` AS `CurrencyCountry` LEFT JOIN `demoe3_getezquotes`.`currencies` AS `Currency` ON (`CurrencyCountry`.`currency_id` = `Currency`.`id`) WHERE `CurrencyCountry`.`country_id` = 2 LIMIT 1 | 1 | 1 | 0 | |
SELECT `CategoryCountry`.`category_id`, `Category`.`segment_id`, `Category`.`name`, (SELECT count(`category_countries`.`id`) FROM category_countries LEFT JOIN categories ON `category_countries`.`category_id`=`categories`.`id` WHERE `categories`.`deleted`=0 AND `categories`.`is_active`=1 AND `categories`.`type`='category' AND `categories`.`deleted`=0 AND `category_countries`.`parent_id` = `CategoryCountry`.`category_id` and `category_countries`.`country_id` =2) AS `CategoryCountry__childCategory` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE ((`Category`.`is_active` = 1) AND (`Category`.`deleted` = 0) AND (`Category`.`type` = 'category') AND (`CategoryCountry`.`country_id` = 2) AND (`Category`.`segment_id` != 0)) AND `Category`.`parent_id` = 0 ORDER BY `Category`.`segment_id` ASC, `Category`.`name` ASC | 168 | 168 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 129 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 134 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 142 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 9 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 160 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 10 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 11 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 168 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 12 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1074 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1081 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 1 | 1 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 16 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 192 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1152 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1175 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 17 | 17 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 18 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1228 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 19 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 20 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 21 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 22 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1391 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 1 | 1 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 242 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 11 | 11 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 23 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1460 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 24 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 25 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 26 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1259 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 28 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 29 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 17 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 414 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 30 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 31 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1492 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1442 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 531 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 454 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 11 | 11 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 476 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 12 | 12 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 33 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 34 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 35 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1539 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 495 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1200 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 36 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 37 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1218 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 513 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 8 | 8 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 40 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 576 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 12 | 12 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1252 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 564 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 612 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 11 | 11 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1269 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 14 | 14 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 631 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 51 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 671 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 38 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 213 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 10 | 10 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1321 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 704 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 721 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 727 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 750 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 8 | 8 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 756 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 8 | 8 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 805 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 710 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1489 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 78 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 857 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 927 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1511 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1371 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 11 | 11 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 894 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1515 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 878 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1386 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 8 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 999 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 12 | 12 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 306 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1426 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 389 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 11 | 11 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1190 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1476 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 1 | 1 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 429 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 23 | 23 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 585 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 770 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 272 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1676 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 54 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 8 | 8 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 150 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 13 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 10 | 10 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 14 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1559 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1233 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 420 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1379 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 910 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1500 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1406 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 8 | 8 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 250 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 13 | 13 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 427 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 548 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 10 | 10 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 591 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1036 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 717 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 325 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 2 | 2 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 822 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 854 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 866 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1206 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 286 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1647 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1648 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 69 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1641 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 642 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 15 | 15 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1682 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 15 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 10 | 10 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 220 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 683 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1632 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 466 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 261 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 10 | 10 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 298 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 437 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 443 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1548 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 10 | 10 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 904 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 490 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 509 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1361 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 915 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 520 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 80 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 556 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 537 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 19 | 19 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 608 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 8 | 8 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1270 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 10 | 10 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 637 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 10 | 10 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 667 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 675 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 7 | 7 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 692 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 9 | 9 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 733 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1138 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 764 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1509 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 921 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 941 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 6 | 6 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 944 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 255 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 958 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 24 | 24 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 349 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 15 | 15 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1535 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1537 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 1 | 1 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1576 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1574 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 4 | 4 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1606 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 0 | 0 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1589 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 12 | 12 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1582 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 5 | 5 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1655 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 15 | 15 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1588 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 14 | 14 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1567 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 3 | 3 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 1595 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 8 | 8 | 0 | |
SELECT `Category`.`slug`, `Category`.`name`, `Category`.`category_description` FROM `demoe3_getezquotes`.`category_countries` AS `CategoryCountry` LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`CategoryCountry`.`category_id` = `Category`.`id`) WHERE `Category`.`show_in_service_directory` = 1 AND `Category`.`is_active` = 1 AND `Category`.`type` = 'category' AND `Category`.`deleted` = 0 AND `Category`.`parent_id` = 336 AND `CategoryCountry`.`country_id` = 2 ORDER BY `Category`.`name` ASC | 8 | 8 | 0 | |
SELECT `Segment`.`id`, `Segment`.`name` FROM `demoe3_getezquotes`.`segments` AS `Segment` WHERE `status` = 1 ORDER BY `name` ASC | 15 | 15 | 0 | |
SELECT `Block`.`page_slug`, `Block`.`block_slug`, `Block`.`description` FROM `demoe3_getezquotes`.`blocks` AS `Block` WHERE `Block`.`page_slug` = 'hire-a-project-manager-hint' AND `Block`.`block_slug` = 'hire-project-manager-hint' LIMIT 1 | 1 | 1 | 0 | |
SELECT `BannerPosition`.`id`, `BannerPosition`.`page_slug`, `BannerPosition`.`page_name`, `BannerPosition`.`allow_category`, `BannerPosition`.`is_random`, `BannerPosition`.`banner_type`, `BannerPosition`.`no_of_banners`, `BannerPosition`.`banner_order`, `BannerPosition`.`time_interval`, `BannerPosition`.`banner_width`, `BannerPosition`.`banner_height`, `BannerPosition`.`banner_position_image`, `BannerPosition`.`created`, `BannerPosition`.`modified` FROM `demoe3_getezquotes`.`banner_positions` AS `BannerPosition` WHERE `BannerPosition`.`page_slug` = 'service-directory' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.`id`, `Banner`.`user_id`, `Banner`.`user_purchased_banner_package_id`, `Banner`.`banner_position_package_id`, `Banner`.`title`, `Banner`.`banner_type`, `Banner`.`link`, `Banner`.`advertiser_name`, `Banner`.`banner_position_id`, `Banner`.`category_id`, `Banner`.`banner_price`, `Banner`.`image`, `Banner`.`start_date`, `Banner`.`end_date`, `Banner`.`unix_start_date`, `Banner`.`unix_end_date`, `Banner`.`actual_end_date`, `Banner`.`duration`, `Banner`.`duration_unit`, `Banner`.`payment_status`, `Banner`.`banner_status`, `Banner`.`is_active`, `Banner`.`is_admin_approved`, `Banner`.`is_deleted`, `Banner`.`reason`, `Banner`.`created`, `Banner`.`modified` FROM `demoe3_getezquotes`.`banners` AS `Banner` WHERE `Banner`.`banner_position_id` = 3 AND `Banner`.`start_date` <= 1734843496 AND `Banner`.`end_date` > 1734843496 AND `Banner`.`is_admin_approved` = 1 AND `Banner`.`is_active` = 1 AND `Banner`.`banner_type` = 'static_banner' AND `Banner`.`payment_status` = 'completed' ORDER BY rand() ASC, `Banner`.`Created` DESC | 0 | 0 | 0 | |
SELECT `Block`.`page_slug`, `Block`.`block_slug`, `Block`.`description` FROM `demoe3_getezquotes`.`blocks` AS `Block` WHERE `Block`.`page_slug` = 'hire-a-project-manager-hint' AND `Block`.`block_slug` = 'hire-project-manager-hint' LIMIT 1 | 1 | 1 | 0 | |
SELECT `BannerPosition`.`id`, `BannerPosition`.`page_slug`, `BannerPosition`.`page_name`, `BannerPosition`.`allow_category`, `BannerPosition`.`is_random`, `BannerPosition`.`banner_type`, `BannerPosition`.`no_of_banners`, `BannerPosition`.`banner_order`, `BannerPosition`.`time_interval`, `BannerPosition`.`banner_width`, `BannerPosition`.`banner_height`, `BannerPosition`.`banner_position_image`, `BannerPosition`.`created`, `BannerPosition`.`modified` FROM `demoe3_getezquotes`.`banner_positions` AS `BannerPosition` WHERE `BannerPosition`.`page_slug` = 'services-directory-popup' LIMIT 1 | 1 | 1 | 0 | |
SELECT `Banner`.`id`, `Banner`.`user_id`, `Banner`.`user_purchased_banner_package_id`, `Banner`.`banner_position_package_id`, `Banner`.`title`, `Banner`.`banner_type`, `Banner`.`link`, `Banner`.`advertiser_name`, `Banner`.`banner_position_id`, `Banner`.`category_id`, `Banner`.`banner_price`, `Banner`.`image`, `Banner`.`start_date`, `Banner`.`end_date`, `Banner`.`unix_start_date`, `Banner`.`unix_end_date`, `Banner`.`actual_end_date`, `Banner`.`duration`, `Banner`.`duration_unit`, `Banner`.`payment_status`, `Banner`.`banner_status`, `Banner`.`is_active`, `Banner`.`is_admin_approved`, `Banner`.`is_deleted`, `Banner`.`reason`, `Banner`.`created`, `Banner`.`modified` FROM `demoe3_getezquotes`.`banners` AS `Banner` WHERE `Banner`.`banner_position_id` = 18 AND `Banner`.`start_date` <= 1734843497 AND `Banner`.`end_date` > 1734843497 AND `Banner`.`is_admin_approved` = 1 AND `Banner`.`is_active` = 1 AND `Banner`.`banner_type` = 'static_banner' AND `Banner`.`payment_status` = 'completed' ORDER BY rand() ASC, `Banner`.`Created` DESC | 0 | 0 | 0 | |
SELECT `Country`.`id`, `Country`.`slug`, `Country`.`name`, `Country`.`country_code`, `Country`.`is_default`, `Country`.`country_flag` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE `Country`.`show_in_menu` = 1 AND `Country`.`status` = 1 ORDER BY `country_order` ASC, `name` ASC | 3 | 3 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`users` AS `User` LEFT JOIN `demoe3_getezquotes`.`user_groups` AS `UserGroup` ON (`User`.`user_group_id` = `UserGroup`.`id`) WHERE `user_type` = 'service-provider' AND ((`is_blocked` = 0) AND (`is_deleted` = 0) AND (`is_apporoved` = 1) AND (`status` = 1) AND (`activation_key` = '')) | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`users` AS `User` LEFT JOIN `demoe3_getezquotes`.`user_groups` AS `UserGroup` ON (`User`.`user_group_id` = `UserGroup`.`id`) WHERE `user_type` = 'user' | 1 | 1 | 0 | |
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`projects` AS `Projects` LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`Projects`.`user_id` = `User`.`id`) WHERE `Projects`.`status` = 1 AND `Projects`.`is_admin_approved` = 1 AND `Projects`.`is_posted` = 1 AND `Projects`.`is_deleted` = 0 AND `User`.`is_deleted` = 0 AND `User`.`is_blocked` = 0 | 1 | 1 | 0 | |