![]() |
Home / Product Product Query execute error in /home/users/test7/public_html/WEB-INF/classes/clsDataBase.php::OpenResultSet: You have an error in your SQL syntax near '= s.id OR sc.id = ) AND p.is_visible = 1 AND (p.description LIKE '%%' OR p.large' at line 1Source query: SELECT count(*) as total, CEILING( count(*) / 25 ) as steps, '0' as current, FLOOR( 0 / 25 ) + 1 as cstep, LEAST(GREATEST( CEILING(FLOOR(0 / 25 ) - (5/2) + 1), 1), GREATEST(CEILING(count(*)/25) - 5 + 1, 1)) as fs, 25 as pagestep, 5 as navsteps, 't' as type FROM vProduct p Left Join Registry r on r.id = p.id Left Join SubCategory s On s.id = r.parent_id Left Join Registry reg on reg.id = s.id Left Join SubCategory sc on sc.id = reg.parent_id LEFT JOIN HTMLData ON HTMLData.id = p.id WHERE ( = s.id OR sc.id = ) AND p.is_visible = 1 AND (p.description LIKE '%%' OR p.large_description LIKE '%%' OR HTMLData.html LIKE '%%' OR '' = '') |