SELECT SQL_CALC_FOUND_ROWS DISTINCT i.*, p.is_paid, p.hot_swop, IF( IF(sold = 0 ,datediff('2018-12-17 18:10:01',DateTo) > 0 ,datediff('2018-12-17',sold_time) > 14),1,0) AS is_expired, (SELECT m.Name FROM items_model AS m WHERE i.ItemModel = m.ID ) AS ItemModel_Name, (SELECT t.Name FROM items_type AS t WHERE i.ItemType = t.ID ) AS ItemType_Name, (SELECT CONCAT(a.firstname,' ',a.lastname) FROM agent AS a WHERE a.agent_id = i.agent_id ) AS agent_name, (SELECT r.name FROM regions AS r WHERE r.region_id = i.City ) AS City_Name, (SELECT r.name FROM regions AS r WHERE r.region_id = i.Country ) AS Country_Name FROM items AS i LEFT JOIN items_payment AS p ON i.ID = p.swop_id AND p.date_from <= '2018-12-17 18:10:01' AND p.date_to >= '2018-12-17 18:10:01' WHERE 1 AND i.agent_id = AND Live = 1 AND pay_status = 1 AND IF(sold = 0 ,datediff('2018-12-17',DateTo) <= 14 ,datediff('2018-12-17',sold_time) <= 14) ORDER BY IF( IF(sold = 0 ,datediff('2018-12-17 18:10:01',DateTo) > 0 ,datediff('2018-12-17',sold_time) > 14),1,0) ASC, p.is_paid DESC, p.creation_date DESC, sold, LastUpdateTime DESC LIMIT 0,12 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND Live = 1 AND pay_status = 1 AND IF(sold = 0 ' at line 39 SELECT * FROM agent WHERE 1 AND agent_id = LIMIT 1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 3

's Swop

This account have no swops.
  • Travel Vietnam, Cambodia, Thailand, Laos with Wide Eyed Tours
  • Vietnam Motorcycle Tours, Honda Motorbike Tours Vietnam, SE Asia
  • Phong Nha Farmstay - Tailored Adventure Tourism in Real Vietnam!
  • Beach Bar Hue backpacker hostel accommodation
  • Backpacker accommodation at The Hideout Hostel Saigon Ho Chi Minh City
  • Traveldudes.org
  • Rent motorbike bike vietnam vn