Bienes Raíces / Propiedades Publicadas

SELECT COUNT(*) AS `aggregate` FROM `bienes` WHERE `published` = '1' AND `filename` != ''

SELECT * FROM `bienes` WHERE `published` = '1' AND `filename` != '' ORDER BY `created_at` DESC LIMIT 10 OFFSET 20

SELECT * FROM `agentes` WHERE `id` IN ('1')

SELECT * FROM `categorias` WHERE `id` IN ('1', '7', '2', '3', '5')

SELECT * FROM `tipos` WHERE `id` IN ('2', '1')

SELECT * FROM `categories` WHERE `published` = '1' ORDER BY `order` ASC

SELECT * FROM `subcategories` WHERE `category_id` IN ('2', '4', '3', '5', '8', '6') AND (`published` = '1') ORDER BY `name` ASC

SELECT * FROM `website` WHERE `id` = '1' LIMIT 1

SELECT * FROM `contents` WHERE `published` = '1' AND `filename` != '' AND DATE(created_at) >= CURDATE() - INTERVAL 7 DAY ORDER BY `viewed` DESC, `created_at` DESC LIMIT 10

SELECT * FROM `authors` WHERE `id` IN ('5', '1')

SELECT * FROM `categories` WHERE `id` IN ('6', '8', '2', '3', '1')

SELECT * FROM `subcategories` WHERE `id` IN ('16', '44', '45', '39', '7', '38', '27', '25')

SELECT * FROM `contents` WHERE `published` = '1' AND `filename` != '' ORDER BY `created_at` DESC LIMIT 10

SELECT * FROM `authors` WHERE `id` IN ('1')

SELECT * FROM `categories` WHERE `id` IN ('8', '4', '2', '3', '1')

SELECT * FROM `subcategories` WHERE `id` IN ('39', '21', '30', '45', '7', '27', '38', '8')

SELECT * FROM `advertising` WHERE `published` = '1' AND `filename2` != '' ORDER BY RAND() ASC LIMIT 5

SELECT * FROM `bienes` WHERE `published` = '1' AND `filename` != '' ORDER BY RAND() ASC LIMIT 6

SELECT * FROM `municipios` WHERE `id` IN ('1813', '2010', '1807', '1932')

SELECT * FROM `estados` WHERE `id` IN ('23', '26', '28')

SELECT * FROM `agentes` WHERE `id` IN ('1')

SELECT * FROM `advertising` WHERE `published` = '1' AND `filename1` != '' ORDER BY RAND() ASC LIMIT 1

SELECT * FROM `photosizes` WHERE `id` = '3' LIMIT 1