All companies in Wales

This page lists the companies that belong to the category - Business. You can find reviews, addresses and phone numbers, and also add your company to the list.

Quick go:

Popular companies in Wales

Types of companies

1SELECT * FROM `region` WHERE url = 'wls' LIMIT 1
16SELECT * FROM `item` WHERE `region_id` = 4 ORDER BY count_views LIMIT 6
0SELECT * FROM `region` WHERE id IN ('4') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('11838','11027','11364','10865','11705') LIMIT 5
1SELECT * FROM `photos` WHERE `item_id` IN ('264780','580622','122931','172317','412049','634467')
0SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('264780','580622','122931','172317','412049','634467')
2SELECT * FROM `category` WHERE id IN ('1','10','31','4','24') LIMIT 5
24SELECT * FROM `locality` WHERE `region_id` = 4 ORDER BY count_views LIMIT 24
40SELECT * FROM `reviews` WHERE `status` = 1 AND `region_id` = 4 AND `date` < '2020-09-26 11:53:06' ORDER BY `date` DESC LIMIT 3
0SELECT * FROM `region` WHERE id IN ('4') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('11027','11261','11297') LIMIT 3
1SELECT * FROM `item` WHERE id IN ('805735','170573','170580') LIMIT 3
55SELECT category_id FROM category_item WHERE region_id = 4 GROUP BY category_id
1SELECT * FROM `category` WHERE `id` IN ('1','2','3','4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','40','41','42','43','44','45','46','47','48','49','50','51','52','53','54','55','56','57','58','59','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','95','96') ORDER BY name
0SELECT * FROM counts where updated="2020-09-26" and table_name like 'news'
1SELECT * FROM counts where updated="2020-09-26" and table_name like 'news'
1SELECT * FROM `category` ORDER BY name
5SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
1SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
2SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
1SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
1SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
1SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
4SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
1SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
0SELECT * FROM `photos` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `photos`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 1
4SELECT * FROM `item` WHERE `id` IN ('829665','131780','837700','163034','567619','179777','123804','504175','11560','354594','931352','675284')
1SELECT * FROM `region` WHERE id IN ('1','3') LIMIT 2
1SELECT * FROM `locality` WHERE id IN ('7577','732','10230','8384','8950','4293','8230','729','5772','8203','4010','5060') LIMIT 12
1SELECT * FROM `photos` WHERE `item_id` IN ('11560','123804','131780','163034','179777','354594','504175','567619','675284','829665','837700','931352')
1SELECT item_id, category_id FROM `category_item` WHERE item_id IN ('11560','123804','131780','163034','179777','354594','504175','567619','675284','829665','837700','931352')
3SELECT * FROM `category` WHERE id IN ('1','6','10','31','4','11','17','49') LIMIT 8
2SELECT * FROM counts where updated="2020-09-26" and table_name like 'locality'
0SELECT MIN(id) FROM `locality`
1SELECT * FROM `locality` WHERE id IN ('8028','4189','1418','9201','3291','5441','304','1302','10937','7009','1016','4726','7034','3621','4000','11050','6724','6749','8454','8099','7448','2524') LIMIT 12
0SELECT * FROM `region` WHERE id IN ('1') LIMIT 1
1SELECT * FROM counts where updated="2020-09-26" and table_name like 'locality'
0SELECT * FROM counts where updated="2020-09-26" and table_name like 'item'
0SELECT * FROM counts where updated="2020-09-26" and table_name like 'reviews'
2SELECT * FROM counts where updated="2020-09-26" and table_name like 'photos'