Unknown column 't1.type' in 'where clause' In query: SELECT t0.alias,t1.*, t2.*, t3.*,p1.name AS folderName,p2.alias AS folderAlias,`o1`.`value` AS `exist`,`o2`.`name` AS `brand`,`o3`.`value` AS `type`,`o4`.`value` AS `npr`,`o5`.`value` AS `ctypel`,`o6`.`value` AS `spos`,`o7`.`value` AS `rasp`,`o8`.`value` AS `kamera`,`o9`.`value` AS `kam`,`o10`.`value` AS `worranty` FROM `entity_cache` AS t0,`data_vheat` AS t1, `entity` AS t2, `text_vheat` AS t3,`entity` AS p1,`data_category` AS p2,`options` AS `o1`,`entity` AS `o2`,`options` AS `o3`,`options` AS `o4`,`options` AS `o5`,`options` AS `o6`,`options` AS `o7`,`options` AS `o8`,`options` AS `o9`,`options` AS `o10` WHERE t0.alias='gazovyj-protochnyj-vodonagrevatel-lemax-evro-20' AND t1.id=t0.id AND t2.id=t1.id AND t3.id=t1.id AND p1.id=t2.parent_id AND p2.id=p1.id AND t1.`exist`=`o1`.`id` AND t1.`brand`=`o2`.`id` AND t1.`type`=`o3`.`id` AND t1.`npr`=`o4`.`id` AND t1.`ctypel`=`o5`.`id` AND t1.`spos`=`o6`.`id` AND t1.`rasp`=`o7`.`id` AND t1.`kamera`=`o8`.`id` AND t1.`kam`=`o9`.`id` AND t1.`worranty`=`o10`.`id` LIMIT 1
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY `entity_id` ASC, `order` ASC' at line 1 In query: SELECT id,attribute_id,file,ext,name,description FROM `file` WHERE entity_id= ORDER BY `entity_id` ASC, `order` ASC
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t2.id=t1.attribute_id
ORDER BY t1.id ASC' at line 4 In query: SELECT t2.alias, t2.name, t1.value_varchar AS `char`, value_int AS `int`
FROM `multidata` AS t1, `attributes` AS t2
WHERE t1.entity_id=
AND t2.id=t1.attribute_id
ORDER BY t1.id ASC
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ORDER BY t1.id ASC' at line 7 In query: SELECT t2.id, t2.name, t1.price, t3.description, t1.link
FROM `data_uslugi` AS t1
JOIN `entity` AS t2 ON t2.id=t1.id
JOIN `text_uslugi` AS t3 ON t3.id=t2.id
WHERE
t1.gruppa=
ORDER BY t1.id ASC
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND t2.parent_id=
AND t1.photo!=''
AND t2.hid...' at line 16 In query: SELECT
t1.*,
t1.photo,
t2.*,
t3.name AS foldername,
t4.alias AS folderalias,
t5.alias AS parentalias,
t5.id AS mfid
FROM `entity_cache` AS t1
JOIN `entity` AS t2 ON t2.id=t1.id
JOIN `entity` AS t3 ON t3.id=t2.parent_id
JOIN `data_category` AS t4 ON t4.id=t3.id
JOIN `data_category` AS t5 ON t5.id=t3.parent_id
WHERE
t1.id !=
AND t2.parent_id=
AND t1.photo!=''
AND t2.hidden='0'
ORDER BY
RAND()
LIMIT 18