exit($query);
сорри, я выложил то что было по умолчанию.
Вот мой:
SELECT prod.product_id, pr_cat.category_id, prod.`name_ru-RU` as name, prod.`short_description_ru-RU` as short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id, prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count, prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price, prod.product_quantity, prod.different_prices, prod.delivery_times_id, prod.`extra_field_1` , prod.`extra_field_2` , prod.`extra_field_3` , prod.`extra_field_24` , prod.`extra_field_25` , prod.`extra_field_26` , prod.`extra_field_34` , prod.`extra_field_4` , prod.`extra_field_31` , prod.`extra_field_5` , prod.`extra_field_33` , prod.`extra_field_32` , prod.`extra_field_23` , prod.`extra_field_7` , prod.`extra_field_11` , prod.`extra_field_27` , prod.`extra_field_28` , prod.`extra_field_29` , prod.`extra_field_30` , prod.`extra_field_35` , prod.`extra_field_37` , prod.`extra_field_36` , prod.`extra_field_42` , prod.`extra_field_43` , prod.`extra_field_44` , prod.`extra_field_45` , prod.`extra_field_48` , prod.`extra_field_50` , prod.`extra_field_51` , prod.`extra_field_52` , prod.`extra_field_49` , prod.`extra_field_57` , prod.`extra_field_54` , prod.`extra_field_55` , prod.`extra_field_56` , prod.`extra_field_58` , prod.`extra_field_59` , prod.`extra_field_6` , prod.`extra_field_14` , prod.`extra_field_20` , prod.`extra_field_21` , prod.`extra_field_22` , prod.`extra_field_38` , prod.`extra_field_39` , prod.`extra_field_40` , prod.`extra_field_8` , prod.`extra_field_9` , prod.`extra_field_41` , prod.`extra_field_65` , prod.`extra_field_61` , prod.`extra_field_60` , prod.`extra_field_64` , prod.`extra_field_63` , prod.`extra_field_62` , prod.`extra_field_12` , prod.`extra_field_13` , prod.`extra_field_10` , prod.`extra_field_18` , prod.`extra_field_19` , prod.`extra_field_15` , prod.`extra_field_16` , prod.`extra_field_17` , prod.vendor_id, IF(prod.product_quantity>0,1,0) as qflag FROM `#__jshopping_products` AS prod INNER JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish=1 AND cat.category_publish=1 AND prod.product_quantity > 0 AND pr_cat.category_id IN (4) AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) GROUP BY prod.product_id order by prod.product_price asc LIMIT 23, 10