Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- p.p_name,
- p.id,
- cat.cat_name,
- p.property_type,
- p.p_type,
- p.address,
- c.client_name,
- p.price,
- GROUP_CONCAT(pr.price) AS c_price,
- pd.land_area,
- pd.land_area_rp,
- p.tagline,
- p.map_location,
- r.id,
- p.status,
- co.country_name,
- p.`show`,
- u.name,
- p.created_date,
- p.updated_dt,
- o.type_id,
- p.furnished,
- p.expiry_date
- FROM
- property p
- LEFT OUTER JOIN region AS r
- ON p.district_id = r.id
- LEFT OUTER JOIN country AS co
- ON p.country_id = co.country_id
- LEFT OUTER JOIN property_category AS cat
- ON p.cat_id = cat.id
- LEFT OUTER JOIN property_area_details AS pd
- ON p.id = pd.property_id
- LEFT OUTER JOIN sc_clients AS c
- ON p.client_id = c.client_id
- LEFT OUTER JOIN admin AS u
- ON p.adminid = u.id
- LEFT OUTER JOIN sc_property_orientation_type AS o
- ON p.orientation_type = o.type_id
- LEFT OUTER JOIN property_amenities_details AS pad
- ON p.id = pad.property_id
- LEFT OUTER JOIN sc_commercial_property_price AS pr
- ON p.id = pr.property_id
- WHERE p.id > 0
- AND (
- p.created_date > DATE_SUB(NOW(), INTERVAL 1 YEAR)
- OR p.updated_dt > DATE_SUB(NOW(), INTERVAL 1 YEAR)
- )
- AND p.p_type = 'sale'
- select count(*)
- from table
- select any(p.p_name) as p_num, any(p.tagline) as tagline, . . .
- GROUP BY
- p.p_name,
- p.id,
- cat.cat_name,
- p.property_type,
- p.p_type,
- p.address,
- c.client_name,
- p.price,
- pd.land_area,
- pd.land_area_rp,
- p.tagline,
- p.map_location,
- r.id,
- p.status,
- co.country_name,
- p.`show`,
- u.name,
- p.created_date,
- p.updated_dt,
- o.type_id,
- p.furnished,
- p.expiry_date
Add Comment
Please, Sign In to add comment