Ministry of Education in Saudi Arabia – KSA – Online Business Directory

Search by

Business Name
Keyword
Category
Brand
Phone Number
Address
PO Box Number

Home
Ministry of Education

Search Results for "Ministry of Education"

Showing 1-20 of listings

Follow us on

Home
About Us
Contact Us
Submit Your Free Listing

City Guide
My Daleeli
Daleeli Services
Feedback

Terms and Conditions
Privacy Policy
Sitemap
Blog

Al Wahda Express Saudi App

All Rights Reserved, © 2017 Al Wahda Express Saudi LLC.

select c.category_id as category_id, c.category_name_en as category_name, c.slug_en as slug, c.category_synonyms_en as category_synonyms, c.category_image_en as category_image, c.company_count as company_count, c.main_parentcatid as parent_category, c.super_category_id as super_category_id, c.subcategory_id as subcategory_id, c.popular_category_id as popular_category_id, c.show_menu as show_menu, c.description_en as category_description,c.meta_keywords_en as meta_keywords, c.meta_desc_en as meta_desc, c.meta_title_en as meta_title FROM yp_categories c WHERE c.category_id IN ( 50125 ) and c.company_count > 0

0.056884765625

SELECT area.area_id AS `area.area_id`, area.area_name_ar AS `area.area_name`, area.area_synonyms_ar AS `area.area_synonyms`, area.city_id AS `area.city_id`, area.gps_longitude AS `area.gps_longitude`, area.gps_latitude AS `area.gps_latitude` FROM yp_areas AS area WHERE area.area_name_en = 'Al Madinah Al Munawarah' or area.area_name_ar = 'Al Madinah Al Munawarah'

0.02783203125

SELECT id, title_en as title, url, target, display_order, status, width, height FROM yp_footer WHERE status = 1 ORDER BY display_order

0.02001953125

SELECT id, page_name, filename, module, keywords_en as keywords, desc_en as description, title_en as title FROM yp_metatags WHERE filename = 'categories.php'

0.025146484375

SELECT city_id, city_name_en as city_name, city_synonyms_en as city_synonyms, directory_id as city_directory_id, display_order as city_display_order, description_en as city_description, gps_longitude as city_gps_longitude, gps_latitude as city_gps_latitude, countryid as city_countryid, meta_keywords_en as meta_keywords, meta_desc_en as meta_desc, meta_title_en as meta_title, about_meta_keywords_en as about_meta_keywords, about_meta_desc_en as about_meta_desc, about_meta_title_en as about_meta_title, (SELECT GROUP_CONCAT(CONCAT(gallary_code, '--', file_name,'--',image_alt_en) SEPARATOR '##') FROM yp_cities_gallary WHERE city_id = yc.city_id) as city_images FROM yp_cities as yc WHERE city_name_en = 'all' OR city_name_ar = 'all'

0.031982421875

select c.category_id as category_id, c.category_name_en as category_name, c.slug_en as slug, c.category_synonyms_en as category_synonyms, c.category_image_en as category_image, c.company_count as company_count, c.main_parentcatid as parent_category, c.super_category_id as super_category_id, c.subcategory_id as subcategory_id, c.popular_category_id as popular_category_id, c.show_menu as show_menu, c.description_en as category_description,c.meta_keywords_en as meta_keywords, c.meta_desc_en as meta_desc, c.meta_title_en as meta_title FROM yp_categories c WHERE c.category_id IN ( 50125 ) and c.company_count > 0

0.01806640625

SELECT area.area_id AS `area.area_id`, area.area_name_en AS `area.area_name`, area.area_synonyms_en AS `area.area_synonyms`, area.city_id AS `area.city_id`, area.gps_longitude AS `area.gps_longitude`, area.gps_latitude AS `area.gps_latitude` FROM yp_areas AS area WHERE area.area_name_en = 'Al Madinah Al Munawarah' or area.area_name_ar = 'Al Madinah Al Munawarah'

0.029052734375

select c.category_id as category_id, c.category_name_en as category_name, c.slug_en as slug, c.category_synonyms_en as category_synonyms, c.category_image_en as category_image, c.company_count as company_count, c.main_parentcatid as parent_category, c.super_category_id as super_category_id, c.subcategory_id as subcategory_id, c.popular_category_id as popular_category_id, c.show_menu as show_menu, c.description_en as category_description,c.meta_keywords_en as meta_keywords, c.meta_desc_en as meta_desc, c.meta_title_en as meta_title FROM yp_categories c WHERE c.category_id IN ( 50125 ) and c.company_count > 0

0.017333984375

select c.category_id as category_id, c.category_name_en as category_name, c.slug_en as slug, c.category_synonyms_en as category_synonyms, c.category_image_en as category_image, c.company_count as company_count, c.main_parentcatid as parent_category, c.super_category_id as super_category_id, c.subcategory_id as subcategory_id, c.popular_category_id as popular_category_id, c.show_menu as show_menu, c.description_en as category_description,c.meta_keywords_en as meta_keywords, c.meta_desc_en as meta_desc, c.meta_title_en as meta_title FROM yp_categories c WHERE c.category_id IN ( 50125 ) and c.company_count > 0

0.017333984375

SELECT area.area_id AS `area.area_id`, area.area_name_en AS `area.area_name`, area.area_synonyms_en AS `area.area_synonyms`, area.city_id AS `area.city_id`, area.gps_longitude AS `area.gps_longitude`, area.gps_latitude AS `area.gps_latitude` FROM yp_areas AS area WHERE area.area_name_en = 'Al Madinah Al Munawarah' or area.area_name_ar = 'Al Madinah Al Munawarah'

0.026123046875

select c.category_id as category_id, c.category_name_en as category_name, c.slug_en as slug, c.category_synonyms_en as category_synonyms, c.category_image_en as category_image, c.company_count as company_count, c.main_parentcatid as parent_category, c.super_category_id as super_category_id, c.subcategory_id as subcategory_id, c.popular_category_id as popular_category_id, c.show_menu as show_menu, c.description_en as category_description,c.meta_keywords_en as meta_keywords, c.meta_desc_en as meta_desc, c.meta_title_en as meta_title FROM yp_categories c WHERE c.category_id IN ( 50125 ) and c.company_count > 0

0.02001953125

(((category_ids:"50125")) AND (sponsor_value:50125) ) AND (area_id:)

4.519775390625

((category_ids:"50125")) AND (sponsor_value:50125)

0

0

1.021240234375

((category_ids:"50125")) AND (area_id:) ORDER : investment:desc,company_name_en:asc

1.760009765625

((category_ids:"50125")) AND (area_id:) ORDER : investment:desc,company_name_en:ascGROUP : first_character_en

1.7109375

(( brand_name_en:Ministry AND brand_name_en:of AND brand_name_en:Education)OR( brand_synonyms_en:Ministry AND brand_synonyms_en:of AND brand_synonyms_en:Education)) AND (area_id:) ORDER : brand_name_en:asc

1.636962890625

((( category_name_en:Ministry AND category_name_en:of AND category_name_en:Education)OR( category_synonyms_en:Ministry AND category_synonyms_en:of AND category_synonyms_en:Education)) AND (main_parentcatid:0) ) AND (area_id:)

1.743896484375

(((category_name_en:"Ministry of Education")OR(category_synonyms_en:"Ministry of Education")) AND (main_parentcatid:0) ) AND (area_id:)

1.52099609375

((( category_name_en:Ministry AND category_name_en:of AND category_name_en:Education)OR( category_synonyms_en:Ministry AND category_synonyms_en:of AND category_synonyms_en:Education)) AND (main_parentcatid:0) ) AND (area_id:)

1.75390625

((( category_name_en:Ministry AND category_name_en:of AND category_name_en:Education)OR( category_synonyms_en:Ministry AND category_synonyms_en:of AND category_synonyms_en:Education)) AND (main_parentcatid:0) ) AND (area_id:)

2.194091796875

((keyword_name_en:"Ministry of Education")OR(keyword_synonyms_en:"Ministry of Education")) AND (area_id:) ORDER : number_listings:desc

1.675048828125

(category_ids:"50125")GROUP : area_id

1.426025390625

SELECT id, page_name, filename, module, keywords_en as keywords, desc_en as description, title_en as title FROM yp_metatags WHERE filename = 'category.php' AND module = 'search' AND page_name = 'category_main'

0.031005859375

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.keyword in ('0') AND yp_company_services.service_id IN (12138) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 2

0.02099609375

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.service_id IN ( 12138 ) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 2

0.021728515625

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.keyword in ('0') AND yp_company_services.service_id IN (12139) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 1

0.02001953125

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.service_id IN ( 12139 ) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 1

0.02099609375

(category_synonyms_en:"Ministry of Education")OR(category_name_en:"Ministry of Education")

1

1

1.171875

(keyword_synonyms_en:"Ministry of Education")OR(keyword_name_en:"Ministry of Education")

0

0

0.856201171875

(company_name_en:"Ministry of Education")OR(company_synonyms_en:"Ministry of Education")

22

22

2.600830078125

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.category_id IN ( 50125 ) AND yp_company_services.service_id IN (40) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 6

0.02197265625

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.keyword in ('en-50125') AND yp_company_services.service_id IN (40) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 6

0.02001953125

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.company_id IN ('1001312,1004929,1001392,1001993,1001084,1001980,1008323,1008392,1008828,1008111,1008001,1008288,1003902,1004265,1009119,1003975,1003284,1001511,1004546,1007848,1004462,1008217') AND yp_company_services.service_id IN (40) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 6

0.030029296875

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.service_id IN ( 40 ) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 6

0.02001953125

(category_synonyms_en:"Ministry of Education")OR(category_name_en:"Ministry of Education")

1

1

1.42578125

(keyword_synonyms_en:"Ministry of Education")OR(keyword_name_en:"Ministry of Education")

0

0

0.84716796875

(company_name_en:"Ministry of Education")OR(company_synonyms_en:"Ministry of Education")

22

22

2.84521484375

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.category_id IN ( 50125 ) AND yp_company_services.service_id IN (36) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 10

0.01708984375

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.keyword in ('en-50125') AND yp_company_services.service_id IN (36) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 10

0.02099609375

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.company_id IN ('1001312,1004929,1001392,1001993,1001084,1001980,1008323,1008392,1008828,1008111,1008001,1008288,1003902,1004265,1009119,1003975,1003284,1001511,1004546,1007848,1004462,1008217') AND yp_company_services.service_id IN (36) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 10

0.03515625

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.service_id IN ( 36 ) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 10

0.01904296875

(category_synonyms_en:"Ministry of Education")OR(category_name_en:"Ministry of Education")

1

1

1.47509765625

(keyword_synonyms_en:"Ministry of Education")OR(keyword_name_en:"Ministry of Education")

0

0

0.908935546875

(company_name_en:"Ministry of Education")OR(company_synonyms_en:"Ministry of Education")

22

22

2.826904296875

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.category_id IN ( 50125 ) AND yp_company_services.service_id IN (12148) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 1

0.02197265625

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.keyword in ('en-50125') AND yp_company_services.service_id IN (12148) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 1

0.02099609375

select yp_company_services.comp_service_id, yp_company_services.company_id, yp_company_services.service_id, yp_company_services.service_code, yp_company_services.category_id, yp_company_services.start_date, yp_company_services.end_date, yp_company_services.flash_filename, yp_company_services.width, yp_company_services.height, yp_company_services.service_price, yp_company_services.textad_image, yp_company_services.textad_title, yp_company_services.textad_target_url, yp_company_services.banner_file, yp_company_services.banner_url, yp_company_services.keyword, yp_company_services.language, yp_company_services.ns_banner_filename, yp_company_services.ns_banner_file, yp_company_services.sky_ad_description, yp_company_services.sky_ad_title, yp_companies.url, yp_companies.company_name_en, yp_companies.gps_latitude, yp_companies.gps_longitude FROM yp_company_services INNER JOIN yp_companies on yp_companies.company_id = yp_company_services.company_id WHERE yp_company_services.start_date <= CURDATE() AND yp_company_services.end_date >= CURDATE() AND yp_company_services.banner_file NOT LIKE '%.swf' AND yp_company_services.company_id IN ('1001312,1004929,1001392,1001993,1001084,1001980,1008323,1008392,1008828,1008111,1008001,1008288,1003902,1004265,1009119,1003975,1003284,1001511,1004546,1007848,1004462,1008217') AND yp_company_services.service_id IN (12148) AND yp_company_services.language = 'english' ORDER BY rand() LIMIT 0 , 1

0.02685546875