mySQL-Query: select
items.id as id ,
items.if_1 as if_1 ,
items.if_3 as if_3 ,
if6.name as if_6 ,
items.if_14 as if_14 ,
if4.name as if_4 ,
if18.name as if_18 ,
items.if_11 as if_11 ,
if18.name as if_18 ,
items.if_8 as if_8 ,
items.if_4 as if_4 ,
items.if_9 as if_9
from items
left join inputfields as if6 on (if6.inputid=6 && if6.value=items.if_6)
left join inputfields as if4 on (if4.inputid=4 && if4.value=items.if_4)
left join inputfields as if18 on (if18.inputid=18 && if18.value=items.if_18)
left join inputfields as if18 on (if18.inputid=18 && if18.value=items.if_18)
where items.active='Y'
group by items.id
order by rand(), items.if_14
Not unique table/alias: 'if18'
mySQL-Query: select
items.id as id ,
items.if_1 as if_1 ,
items.if_3 as if_3 ,
if6.name as if_6 ,
items.if_14 as if_14 ,
if4.name as if_4 ,
if18.name as if_18 ,
items.if_11 as if_11 ,
if18.name as if_18 ,
items.if_8 as if_8 ,
items.if_4 as if_4 ,
items.if_9 as if_9
from items
left join inputfields as if6 on (if6.inputid=6 && if6.value=items.if_6)
left join inputfields as if4 on (if4.inputid=4 && if4.value=items.if_4)
left join inputfields as if18 on (if18.inputid=18 && if18.value=items.if_18)
left join inputfields as if18 on (if18.inputid=18 && if18.value=items.if_18)
where items.active='Y'
group by items.id
order by rand(), items.if_14
Not unique table/alias: 'if18'
mySQL-Query: select
items.id as id ,
items.if_1 as if_1 ,
items.if_3 as if_3 ,
if6.name as if_6 ,
items.if_14 as if_14 ,
if4.name as if_4 ,
if18.name as if_18 ,
items.if_11 as if_11 ,
if18.name as if_18 ,
items.if_8 as if_8 ,
items.if_4 as if_4 ,
items.if_9 as if_9 ,
items.if_15 as if_15
from items
left join inputfields as if6 on (if6.inputid=6 && if6.value=items.if_6)
left join inputfields as if4 on (if4.inputid=4 && if4.value=items.if_4)
left join inputfields as if18 on (if18.inputid=18 && if18.value=items.if_18)
left join inputfields as if18 on (if18.inputid=18 && if18.value=items.if_18)
where items.active='Y'
group by items.id
order by rand(), items.if_14
Not unique table/alias: 'if18'
mySQL-Query: select
items.id as id ,
items.if_1 as if_1 ,
items.if_3 as if_3 ,
if6.name as if_6 ,
items.if_14 as if_14 ,
if4.name as if_4 ,
if18.name as if_18 ,
items.if_11 as if_11 ,
if18.name as if_18 ,
items.if_8 as if_8 ,
items.if_4 as if_4 ,
items.if_9 as if_9 ,
items.if_15 as if_15
from items
left join inputfields as if6 on (if6.inputid=6 && if6.value=items.if_6)
left join inputfields as if4 on (if4.inputid=4 && if4.value=items.if_4)
left join inputfields as if18 on (if18.inputid=18 && if18.value=items.if_18)
left join inputfields as if18 on (if18.inputid=18 && if18.value=items.if_18)
where items.active='Y'
group by items.id
order by rand(), items.if_14
Not unique table/alias: 'if18'
Euro Camion:
vétel : Állandóan keresünk új járműveket kapcsolat : Euro Camion előre örül az értesítésének