No valid database connection 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 ')
group by a.item_id, country, item_name, item_type, item_desc,item_ph' at line 31 SQL=SELECT
a.item_id,
case when d.highlighted='Y' then 1 else 9 end as high_light,
case when b.city='' then 1 else 9 end as city,
case when b.country_code='US' then 1 else 9 end as country,
item_name,
item_type,
item_desc,
item_photo_thumb,
item_photo_address,
url_given,
currency,
price,
weblink_url,
market_street_address,
market_postcode,
city
FROM jos_pl_item a
join jos_pl_item_market b
on a.item_id=b.item_id AND (b.country_code = coalesce('US' ,'INF'))
join jos_pl_item_name c
on a.item_id=c.item_id
left join jos_pl_item_content d
on a.item_id = d.item_id and d.content_id='96'
where c.lang='fr'
AND CHAR_LENGTH( c.item_name ) >0
and a.item_id in
()
group by a.item_id, country, item_name, item_type, item_desc,item_photo_thumb, item_photo_address,
url_given, currency,price, weblink_url,market_street_address, market_postcode,city
order by rand()
limit 0,5
Inspiration
Soyez assis avec toute la majesté inaltérable et inébranlable de la montagne. Laissez votre esprit s'élever, prendre son essor et planer dans le ciel. Sogyal Rinpoché
