Museum in North Carolina

Our project north-carolina-bd.kom invites you to get acquainted with information about Museum in North Carolina

Quick go:

Types of organizations in North Carolina

0SELECT * FROM `region` WHERE url = 'nc' LIMIT 1
0SELECT * FROM `category` WHERE url = 'museum' LIMIT 1
2SELECT category_id, region_id, locality_id FROM `category_item` WHERE category_id = 270 AND region_id = 66 GROUP BY category_id, region_id, locality_id
11SELECT * FROM `locality` WHERE `region_id` = 66 ORDER BY name
2SELECT category_id FROM category_item WHERE region_id = 66 GROUP BY category_id
1SELECT * FROM `category` WHERE `id` IN ('189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','254','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282') ORDER BY name
1SELECT * FROM counts where updated="2024-05-30" and table_name like 'news'
0SELECT * FROM counts where updated="2024-05-30" and table_name like 'news'
0SELECT * FROM `category` ORDER BY name
4SELECT * FROM `item` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `item`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 8
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM `locality` WHERE id IN ('30940','30477','30661','30578') LIMIT 4
0SELECT * FROM `photos` WHERE `item_id` IN ('490952','490953','490954','490955','490956','490957','490958','490959')
0SELECT * FROM `locality` f JOIN ( SELECT RAND() * (SELECT MAX(id) FROM `locality`) AS max_id ) AS m WHERE f.id >= m.max_id ORDER BY f.id ASC LIMIT 12
0SELECT * FROM `region` WHERE id IN ('66') LIMIT 1
0SELECT * FROM counts where updated="2024-05-30" and table_name like 'locality'
0SELECT * FROM counts where updated="2024-05-30" and table_name like 'item'
0SELECT * FROM counts where updated="2024-05-30" and table_name like 'reviews'
0SELECT * FROM counts where updated="2024-05-30" and table_name like 'photos'