Error selecting record error:1064 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 'ORDER BY horse_ad.photo_flag desc, horse_ad.date_create desc' at line 38 SELECT distinct horse_ad.horse_ad_id, horse_ad.horse_name, horse_breed_val.horse_breed_name, horse_color_val.horse_color_name, horse_gender_val.horse_gender_name, horse_ad.horse_color_desc, horse_ad.sale_price, horse_ad.stud_fee, horse_ad.summary, DATE_FORMAT(horse_ad.date_create, '%D ' '%M ' '%Y') as date_create, business_info.business_id, business_info.member_id, business_info.city, business_info.state_cd, business_info.business_name, business_info.address1, business_info.zip, horse_ad.photo_flag, horse_ad.sale_flag, horse_ad.picture_name, horse_ad.private_treaty, DATE_FORMAT(horse_ad.date_foaled, '%Y') as year_foaled FROM (horse_ad LEFT JOIN horse_use on horse_use.horse_ad_id = horse_ad.horse_ad_id) LEFT JOIN pedigree ON pedigree.horse_ad_id = horse_ad.horse_ad_id, horse_color_val, horse_breed_val, horse_gender_val, business_info WHERE horse_ad.active_flag = 1 and horse_ad.active_flag_adm = 1 and horse_ad.business_id = business_info.business_id and horse_ad.horse_breed_id = horse_breed_val.horse_breed_id and horse_gender_val.horse_gender_id = horse_ad.horse_gender_id and horse_color_val.horse_color_id = horse_ad.horse_color_id and business_info.business_id = ORDER BY horse_ad.photo_flag desc, horse_ad.date_create desc |
||
|
Copyright
(c) 2001,
HorsesOnly.com. All
rights reserved. Created by
Database Decisions.
|
||
