SELECT DISTINCT p.id, CONCAT(m.name, ' ' , p.name) as name, p.picture, p.entrydate FROM phones as p, phonemakers as m, carriers_to_phones as wc2p LEFT JOIN item_to_phones as i2p ON p.makerid=m.id AND p.id=i2p.phoneid WHERE wc2p.carrierid='13' AND wc2p.phoneid=p.id AND i2p.itemid IS NOT NULL order by m.name, p.entrydate DESC, p.nameUnknown column 'p.makerid' in 'on clause'
Warning: Invalid argument supplied for foreach() in /home/content/92/3215492/html/_extlib/_classes/webpage.2.class.php on line 613
|
|||||||||||||||||||||
|
![]() |
![]() |
![]() |
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|